select dwbm,bm, SUM(hj), SUM(gz), SUM(gz+hj) from (SELECT dwbm,bm,0 hj,gz FROM a union all select dwbm,bm,hj,0 gz from b) aa group by dwbm,bm
select dwbm,bm, SUM(hj), SUM(gz), SUM(gz+hj) from (SELECT dwbm,bm,0 hj,gz FROM a union all select dwbm,bm,hj,0 gz from a2) aa group by dwbm,bm
select 单位,部门, (select sum(aaa.gz) from table1 where 单位=aa.单位 and 部门=aa.部门)工资总和, (select sum(bbb.退休金) from table2 where 单位=aa.单位 and 部门=aa.部门)退休金总和 from (select 单位,部门 from table1 group by 单位,部门)aa left jon table1 aaa on aa.单位=aaa.单位 and aa.部门=aaa.部门 left join table2 bbb on aa.单位=bbb.单位 and aa.部门=bbb.部门
SELECT c.dwbm, c.bm, SUM(c.hj), SUM(c.gz), SUM(c.gz + c.hj) FROM ( select a.dwbm, a.bm, a.gz, a2.hj from a FULL JOIN a2 ON a.dwbm = a2.dwbm AND a.bm = a2.bm ) c GROUP BY c.dwbm, c.bm
from
(SELECT dwbm,bm,0 hj,gz FROM a
union all
select dwbm,bm,hj,0 gz from b) aa group by dwbm,bm
from
(SELECT dwbm,bm,0 hj,gz FROM a
union all
select dwbm,bm,hj,0 gz from a2) aa group by dwbm,bm
(select sum(aaa.gz) from table1 where 单位=aa.单位 and 部门=aa.部门)工资总和,
(select sum(bbb.退休金) from table2 where 单位=aa.单位 and 部门=aa.部门)退休金总和 from
(select 单位,部门 from table1 group by 单位,部门)aa left jon table1 aaa on aa.单位=aaa.单位 and aa.部门=aaa.部门 left join table2 bbb on aa.单位=bbb.单位 and aa.部门=bbb.部门
FROM (
select a.dwbm, a.bm, a.gz, a2.hj from a FULL JOIN
a2 ON a.dwbm = a2.dwbm AND a.bm = a2.bm
) c
GROUP BY c.dwbm, c.bm