SELECT a.aid,bid,cid,jg1,jg2 from a表 a inner join b表 b on a.aid=b.aid inner join c表 c on b.aid=c.aid
Union all
select '','','',sum(jg1),sum(jg2) from a表 a inner join b表 b on a.aid=b.aid inner join c表 c on b.aid=c.aid group by a.aid
SELECT a.aid,bid,cid,jg1,jg2 from a a inner join b b on a.aid=b.aid inner join c c on b.aid=c.aid
Union all
select '','','',sum(jg1),sum(jg2) from a a inner join b b on a.aid=b.aid inner join c c on b.aid=c.aid group by a.aid