SQL问题

SQL code:

alter PROCEDURE UP_TudiliuzhuanView_GetTuDiViewList
@UId uniqueidentifier --用户编号
AS
BEGIN
SET NOCOUNT ON;
declare @UFlag int
declare @Uname varchar(100)
declare @UComName varchar(200)
select @UFlag=UFlag,@Uname=Uname from Users where UId=@UId

if @UFlag=2
begin
SELECT distinct(T.city_2),
sum(cast ([TVMianji] as int)) as [TVMianji] ,T.[CITY_2] ,u.UComName
from [hanting].[dbo].[TudiliuzhuanView] as T
inner join Users as u on
T.[CITY_2]=u.uflag4 where
T.[CITY_1]=@Uname and isnumeric(T.[TVMianji]) = 1 and T.CITY_2<>''
--GROUP BY CITY_2
end
if @UFlag=3
begin
SELECT distinct(T.city_4),
sum(cast ([TVMianji] as int)) as [TVMianji] ,T.[CITY_4],u.UComName
from [hanting].[dbo].[TudiliuzhuanView] as T
inner join Users as u on
T.[CITY_4]=u.Uname where
T.[CITY_2]=@Uname and isnumeric(T.[TVMianji]) = 1 and CITY_4<>''
--GROUP BY CITY_4
end
SET NOCOUNT OFF;
END
GO




提示：
 消息 8120，级别 16，状态 1，过程 UP_TudiliuzhuanView_GetTuDiViewList，第 18 行
选择列表中的列 'hanting.dbo.TudiliuzhuanView.CITY_2' 无效，因为该列没有包含在聚合函数或 GROUP BY 子句中。
消息 8120，级别 16，状态 1，过程 UP_TudiliuzhuanView_GetTu