select tab1.Code, tab2.Name, money1, money2, (money1-money2)/money2
from
(
select Code, sum(money) as money1 from Table1 group by Code
) as Tab1 join
(
select Code, Name, sum(money) as money2 from Table2 group by Code, Name
) as Tab2
on tab1.code=tab2.code
from
(
select Code, sum(money) as money1 from Table1 group by Code
) as Tab1 join
(
select Code, Name, sum(money) as money2 from Table2 group by Code, Name
) as Tab2
on tab1.code=tab2.code
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货