这可能很容易,但我不知道我该怎么做。
所以我的代码是这样的
例如
SELECT id,total,total2
FROM (select id, 0 AS total ,t1.total AS total2
FROM table1 t1
union ALL
select id, t2.total AS total, 0 AS total2
FRoM table2 t2)
表明
id------total------totals
001 0 20
001 15 0
我想这样展示
id------total------totals
001 15 20
我怎样才能做到这一点?
非常感谢
之后进行聚合:
SELECT id, sum(total) as total, sum(total2) as total2
FROM (select id, 0 AS total ,t1.total AS total2
FROM table1 t1
union ALL
select id, t2.total AS total, 0 AS total2
FRoM table2 t2
) i
GROUP BY id;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句