Table1:
ID NAME PROD GOOD
1 AA orange 100
1 AA apple 95
1 AA egg 50
------------------------
Tabel2:
ID NAME PROD BAD
1 AA orange 5
1 AA banana 10
---------------------------
想得結果:
ID NAME PROD GOOD BAD
1 AA orange 100 5
1 AA apple 95 0
1 AA egg 50 0
1 AA banana 0 10
謝謝!
ID NAME PROD GOOD
1 AA orange 100
1 AA apple 95
1 AA egg 50
------------------------
Tabel2:
ID NAME PROD BAD
1 AA orange 5
1 AA banana 10
---------------------------
想得結果:
ID NAME PROD GOOD BAD
1 AA orange 100 5
1 AA apple 95 0
1 AA egg 50 0
1 AA banana 0 10
謝謝!
(
select ID,NAME,PROD,GOOD,0 BAD from table1 t1
union all
select ID,NAME,PROD,0 GOOD,BAD from table2 t2
) t
group by id,t.name,t.prod
NVL(Tabel1.GOOD, 0) GOOD, NVL(Tabel2.BAD) BAD
FROM Tabel1 LEFT JOIN Tabel2 ON Tabel1.ID = Tabel2.ID