56,681
社区成员
发帖
与我相关
我的任务
分享
A语句
select t1.name,t2.samount,t2.place
from users t1,
(
select name,parentid,sum(amount) samount,place
from users,CasinoRolling where users.name=CasinoRolling.usergroup
group by parentid,place
) t2 where t1.id=t2.parentid
//--------------------------------------
B语句
select t1.name,t2.amount,t2.place
from users t1 inner join
(
select parentid,sum(amount) as amount,place
from users inner join CasinoRolling ON (name=usergroup)
group by parentid,place
) t2 ON t1.id=t2.parentid