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

   

 



[Non-text portions of this message have been removed]



--
-----------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/
 

Kirim email ke