2,668
社区成员
发帖
与我相关
我的任务
分享
select time,编号,sum(容量) 容量,sum(台数) 台数,sum(次数) 次数,sum(数量) 数量
from
(
select time,编号,容量,台数,次数,数量 from a
union all
select time,编号,容量,台数,0 次数,0 数量 from b
)
group by time,编号
select nvl(a.time, b.time) as time,
nvl(a.编号, b.编号) as "编号",
nvl(a.容量, 0) + nvl(b.容量, 0) as "容量",
nvl(a.台数, 0) + nvl(b.台数, 0) as "台数",
nvl(a.次数, b.次数) as "次数",
nvl(a.数量, b.数量) as "数量"
from a full join b
on a.time = b.time
and a.编号 = b.编号;