select distinct t.* from (select t1.a,t1.b,t1. c,t2.d,t2. e from table1 t1 left join t2 on t1.a =t2.A union all select t2.a,t1.b,t1. c,t2.d,t2. e fromt table2 t2 left join t1 on t1.a =t2.A) t
hasilnya 3 tetap muncul. >> | A | B | C | D | E |* >> | 1 | X | Y | Q | W | >> | 2 | T | U | | | >> | 3 | | | P | R | On 4/19/10, Alwin Sanjaya <[email protected]> wrote: > Hi mas Sefri, > Apakah seperti ini? (CMIIW) > > select kolom1, kolom2, kolom3, kolom12, kolom13 > from ( > select 'A' kolom1, 'B' kolom2, 'C' kolom3 from dual > union > select '1' kolom1, 'X' kolom2, 'Y' kolom3 from dual > union > select '2' kolom1, 'T' kolom2, 'U' kolom3 from dual > ) a, > ( > select 'A' kolom11, 'D' kolom12, 'E' kolom13 from dual > union > select '1' kolom11, 'Q' kolom12, 'W' kolom13 from dual > union > select '3' kolom11, 'P' kolom12, 'R' kolom13 from dual > ) b > where a.kolom1 = b.kolom11(+) > > sehingga hasilnya seperti ini : > > > 1 X Y Q W > A B C D E > 2 T U > > yang 3 | - | - | P | R | sepertinya tidak bisa tampil karena tidak ada yang > match dengan join. > > Mungkin teman2 bisa memberikan tambahan? > > Salam, > Alwin.S > www.oblongware.com > Oblongware - Kaos Oblongnya Penggemar IT > > > 2010/4/16 sefrinaldi <[email protected]> > >> >> >> 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] > >
