select b.id,ml=sum((b.ysje-a.cbje)) from b join a on a.id=b.id and a.cbmc=b.ysfy
group by b.id
union all
select 'idall',ml from
(select ml=sum((b.ysje-a.cbje)) from b join a on a.id=b.id and a.cbmc=b.ysfy) aa
group by b.id
union all
select 'idall',ml from
(select ml=sum((b.ysje-a.cbje)) from b join a on a.id=b.id and a.cbmc=b.ysfy) aa
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货