--同一ID的”数值字段1的总和“、”数值字段2的总和“
select ID,SUM(数值字段1) AS 数值字段1的总和,SUM(数值字段2) AS 数值字段2的总和
FROM(
select ID,数值字段1,0 as 数值字段2 from 表1
union all
select ID,0 as 数值字段1,数值字段2 from 表2) T GROUP BY ID
--所有ID的”数值字段1的总和“、”数值字段2的总和“
select SUM(数值字段1) AS 数值字段1的总和,SUM(数值字段2) AS 数值字段2的总和
FROM(
select ID,数值字段1,0 as 数值字段2 from 表1
union all
select ID,0 as 数值字段1,数值字段2 from 表2) T
内容全部来源于网络收集，如有侵权，请联系网站删除！