选择列表中地列 URLSpyList.KeyIndex 无效，因为该列无包含在聚合函数或 GROUP BY 子句中

ALTER procedure [dbo].[GetCountInOperation]
@day datetime
as
select
@day as Date,
left(URLSpyList.KeyIndex,1) as KeyIndex,
sum(IEClassClickCount.MaleCount) as MaleCount,
sum(IEClassClickCount.FeMaleCount) as FeMaleCount,
(sum(IEClassClickCount.MaleCount)+sum(IEClassClickCount.FeMaleCount)) as TotalClickCount,
(sum(IEClassClickCount.Age10MaleCount)+sum(IEClassClickCount.Age10FeMaleCount)) as Age10ClickCount,
sum(IEClassClickCount.Age20MaleCount)+sum(IEClassClickCount.Age20FeMaleCount) as Age20ClickCount,
sum(IEClassClickCount.Age30MaleCount)+sum(IEClassClickCount.Age30FeMaleCount) as Age30ClickCount,
sum(IEClassClickCount.Age40MaleCount)+sum(IEClassClickCount.Age40FeMaleCount) as Age40ClickCount,
sum(IEClassClickCount.Age50MaleCount)+sum(IEClassClickCount.Age50FeMaleCount) as Age50ClickCount,
sum(IEClassClickCount.AgeOtherMaleCount)+sum(IEClassClickCount.AgeOtherFeMaleCount) as AgeOtherClickCount
from URLSpyList,IEClassClickCount,IEClassTop3Click
where URLSpyList.KeyIndex=IEClassClickCount.IEClass and IEClassClickCount.IEClass=IEClassTop3Click.KeyIndex and IEClassClickCount.AnalysisTime=@day
group by left(URLSpyList.KeyIndex,1) order by URLSpyList.KeyIndex

KeyIndex
101
102
103
201
202
203
301
302
303
401
402
403
就报如上错误 怎么解决

---

这个问题第1个回答：
group by left(URLSpyList.KeyIndex,1) order by left(URLSpyList.KeyIndex,1)

---