--åä¸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
温馨提示:内容为网友见解,仅供参考