谁帮我把这段SQL查询改成Access的查询
情绝书生 2007-04-08 04:36:00 select GuestID,LoginID,Name,ActivatePrice
into #t from mAccount a
where exists(
select * from mAccount where GuestID='8888'and LoginID=a.GuestID)
while @@rowcount>0
update a set ActivatePrice=a.ActivatePrice*b.ActivatePrice,LoginID=b.LoginID,Name=b.Name
from #t a,(
select GuestID,LoginID,Name,ActivatePrice
from mAccount a
where exists(
select * from #t where LoginID=a.GuestID)
)b where a.LoginID=b.GuestID
selectGuestID,LoginID,Name,ActivatePrice=Sum(ActivatePrice)
from #t
group by GuestID,LoginID,Name
drop table #t
go