select
A.a_ex,
B.b_ex,
C.c_ex,
A.a_ex-(B.b_ex+C.c_ex) QTY
from A, B, C
where a.num= b.num(+)
and a.num= c.num(+)
이렇게하였는데 아래와같이 없는건 안되네요 원래 계산되어야하지않나요?
A.a_ex | B.b_ex | C.c_ex | abc_ex |
450000 | 330000 | 30000 | 90000 |
300000 | 90000 | 64000 | 146000 |
501000 | 72000 | 90000 | 339000 |
2100000 | 246000 | 480000 | 1374000 |
150000 | 148000 | ||
50000 | 30000 | ||
80000 | 36000 | ||
100000 | 0 |