3,491
社区成员
发帖
与我相关
我的任务
分享
select a.box, a.position, decode(nvl(c.action,-2),-2,a.used,a.used + c.action) used
from A,
(select box, position, sum(action) action
from (select box, position, decode(action, '-', -1, 1) action
from B)
group by box, position) C
where a.box = c.box(+)
and a.position = c.position(+)
select a.box, a.position, decode(nvl(c.action,'-2'),a.used,a.used + c.action) used
from A,
(select box, position, sum(action) action
from (select box, position, decode(action, '-', -1, 1) action
from B)
group by box, position) C
where a.box = c.box(+)
and a.position = c.position(+)