Hallo rekan rekan oracle mania,

Saya mau bertanya mengenai full outer join.yang akan saya buat sebagai view.

Saya membuatnya seperti contoh dibawah ini :

select kode_barang,qty from fsdprswc,fsdpreqc where fsdprswc.kode_barang = 
fsdpreqc.qty (+)
UNION
select kode_barang,qty from fsdprswc,fsdpreqc where fsdprswc.kode_barang (+) = 
fsdpreqc.qty ;

Pertanyaannya :

Mengapa pada saat saya membuat sql command spt diatas keluar message spt 
dibawah ini

ERROR at line 1:
ORA-00918: column ambiguously defined.

Tolong ya....

thank's

---
This email server is protected by Clam AntiVirus (www.clamav.net)


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

Bergabung dengan Indonesia Thin Client User Groups, 
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indo-oracle/

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