select 字段名1,字段名2=sum(字段名2),字段名3=sum(字段名3)
from(
select 字段名1,字段名2,字段名3=0 from A表
union all
select 字段名1,字段名2=0,字段名3 from B表
)a group by 字段名1
from(
select 字段名1,字段名2,字段名3=0 from A表
union all
select 字段名1,字段名2=0,字段名3 from B表
)a group by 字段名1
from(
select 字段名1,字段名2=sum(字段名2) from A表 group by 字段名1
)a,(
select 字段名1,字段名3=sum(字段名3) from A表 group by 字段名1
)b where a.字段名1=b.字段名1
select 字段名1,sum(字段名2) as 字段名2 from A GROUP BY 字段名1) T1,
(select 字段名1,sum(字段名3) as 字段名3 from B GROUP BY 字段名1) T2
WHERE T1.字段名1=T2.字段名1
on a.field1 = b.field1
from(select 字段名1,字段名2=sum(字段名2) from A表 group by 字段名1) AS A JOIN
(select 字段名1,字段名3=sum(字段名3) from B表 group by 字段名1 ) AS B
ON A.字段名1=B.字段名1