sql语句出现错误？

[好好小妖]

select a.ProvincialCentreNumber,a.ProvincialCentreNumberCn,
Sum(DepositCount) as DepositCount,
Sum(Deposit) as Deposit,
(case when DepositCount>0 then Deposit/DepositCount else 0 end) as AvgDeposit
from Provincial a
left join AbFund b on a.ProvincialCentreId=b.ProvincialCentreId
where date='0910'
group by a.ProvincialCentreNumber,a.ProvincialCentreNumberCn,AvgDeposit

出现AvgDeposit 无效列名的错误，请问如何修改？

[icelovey]

select a.ProvincialCentreNumber,a.ProvincialCentreNumberCn, 
	Sum(DepositCount) as DepositCount, 
	Sum(Deposit) as Deposit, 
	(case when DepositCount>0 then Deposit/DepositCount else 0 end) as AvgDeposit 
from Provincial a left join AbFund b on a.ProvincialCentreId=b.ProvincialCentreId 
where date='0910' 
group by a.ProvincialCentreNumber,a.ProvincialCentreNumberCn,
	(case when DepositCount>0 then Deposit/DepositCount else 0 end)

[yujiang930]

group by 不用引用别名必须

group by a.ProvincialCentreNumber,a.ProvincialCentreNumberCn,AvgDeposit 
改为
group by a.ProvincialCentreNumber,a.ProvincialCentreNumberCn,(case when DepositCount>0 then Deposit/DepositCount else 0 end)

[guguda2008]

select a.ProvincialCentreNumber,a.ProvincialCentreNumberCn,
Sum(DepositCount) as DepositCount,
Sum(Deposit) as Deposit,
(case when DepositCount>0 then Deposit/DepositCount else 0 end) as AvgDeposit
from Provincial a
left join AbFund b on a.ProvincialCentreId=b.ProvincialCentreId
where date='0910'
group by a.ProvincialCentreNumber,a.ProvincialCentreNumberCn
,(case when DepositCount>0 then Deposit/DepositCount else 0 end) 

[icelovey]

AvgDeposit 是你上面AS出来的别名, 你不能GROUP BY 别名

[yujiang930]

靠，这都没抢到！！郁闷了

[icelovey]

, 多打几个字就到4楼了..