Siang, semoga ini bisa membantu.. select decode(t1.A,null,t2.A,t1.A) as A, 1.B, t1.C, t2.D, t2.E from table1 t1 left outer join table2 t2 on t1.a = t2.a union select decode(t1.A,null,t2.A,t1.A) as A, t1.B, t1.C, t2.D, t2.E from table1 t1 right outer join table2 t2 on t1.a = t2.a;
Union/Intersect/Minus = http://ss64.com/ora/union.html Terima kasih, Citra --- On Fri, 4/16/10, sefrinaldi <[email protected]> wrote: From: sefrinaldi <[email protected]> Subject: [indo-oracle] newbie tanya query.. To: [email protected] Date: Friday, April 16, 2010, 9:38 AM pagi, mau tanya query donk, maklum masih cupu :D saya punya 2 tabel, tabel 1 : *| A | B | C |* | 1 | X | Y | | 2 | T | U | tabel 2 : *| A | D | E |* | 1 | Q | W | | 3 | P | R | nah saya pengen gabungin kedua tabel itu sehingga kolomnya menjadi : *| A | B | C | D | E |* | 1 | X | Y | Q | W | | 2 | T | U | - | - | | 3 | - | - | P | R | jadi semua record field 'A' di tabel 1 dan table 2 di tampilin.. mohon petunjuknya, . Salam, .aldi [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
