Wah sudah berhasil Makasih atas bantuannya tomi.... -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Tomi Wijanto Sent: 03 Nopember 2006 11:55 To: [email protected] Subject: Re: [indo-oracle] MERUBAH TAMPILAN FULL OUTER JOIN
coba tambahkan ORDER BY NVL(A.ID,B.ID) regards, tomi --- M Reza Firdausi <[EMAIL PROTECTED]> wrote: > Salam rekan2 milis semua, > > > > Mohon bantuannya nih untuk para pakar2 oracle > > Aku ada masalah untuk tampilan query menggunakan > full outer join, > > Masalahnya sbb: > > - aku menggunakan query ini : > > SELECT * FROM > > TES1 A > > FULL OUTER JOIN TES2 B ON A.ID=B.ID > > > > - hasilnya adalah sbb : > > ID NAMA ID NAMA > > -- ---------- -- ---------- > > 01 VITA > > 03 MIRZA > > 04 MAYA > > 02 REZA > > > > -yang saya tanyakan bgm caranya agar tampilan tsb > bisa spt ini : > > ID NAMA ID NAMA > > -- ---------- -- ---------- > > 01 VITA > > 02 REZA > > 03 MIRZA > > 04 MAYA > > > > > > Terima Kasih > > > > Reza ____________________________________________________________________________ ________ Access over 1 million songs - Yahoo! Music Unlimited (http://music.yahoo.com/unlimited) -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
