表1 表2
sn payout sn usernameselect a.sn, b.username, sum(a.payout) as payout
from 表1 a inner join 表2 b on a.sn = b.sn
group by a.sn, b.username
sn payout sn usernameselect a.sn, b.username, sum(a.payout) as payout
from 表1 a inner join 表2 b on a.sn = b.sn
group by a.sn, b.username
select Aa.sn,sum(Aa.payout),Bb.username from @a Aa inner join @b Bb on Aa.sn=Bb.sn group by Aa.sn,Bb.sn应改为:
select Aa.sn,sum(Aa.payout),Bb.username from @a Aa inner join @b Bb on Aa.sn=Bb.sn group by Aa.sn,Bb.username