还是数据库问题

[jdbcodbc]

select top 10 UserAccounts.userid,isnull(Nickname,'') as Nickname ,isnull(sum(GiftCount*50),0) as score, GiftID from UserAccounts
join GiveGiftLog
on UserID2 = UserAccounts.userid
and giftid = 101
and usertype=20
and score>2400000
and RecordTime between DATEADD(ww, DATEDIFF(ww,0,getdate()),0) and DateAdd(ww, 1, DATEADD(ww, DATEDIFF(ww,0,getdate()),0))
group by UserAccounts.userid,Nickname,giftid order by score desc


这里SCORE>2400000是错误的,查询出来的结果是显示列名无效的,应该怎么改啊?

[dawugui]

select top 10 UserAccounts.userid,isnull(Nickname,'') as Nickname ,isnull(sum(GiftCount*50),0) as score, GiftID from UserAccounts 
join GiveGiftLog 
on UserID2 = UserAccounts.userid 
and giftid = 101 
and usertype=20 
and RecordTime between DATEADD(ww, DATEDIFF(ww,0,getdate()),0) and DateAdd(ww, 1, DATEADD(ww, DATEDIFF(ww,0,getdate()),0)) 
group by UserAccounts.userid,Nickname,giftid 
having sum(GiftCount*50) > 2400000
order by score desc 

[htl258_Tony]

select top 10 UserAccounts.userid,isnull(Nickname,'') as Nickname ,isnull(sum(GiftCount*50),0) as score, GiftID from UserAccounts 
join GiveGiftLog 
on UserID2 = UserAccounts.userid 
and giftid = 101 
and usertype=20 
and RecordTime between DATEADD(ww, DATEDIFF(ww,0,getdate()),0) and DateAdd(ww, 1, DATEADD(ww, DATEDIFF(ww,0,getdate()),0)) 
group by UserAccounts.userid,Nickname,giftid
having isnull(sum(GiftCount*50),0)>2400000
order by score desc 

[jdbcodbc]

可以了,太谢谢了