Thank u mass Pri.... kalo untuk fsdprswc.kode_barang = fsdpreqc.qty memang saya salah ketik.... dan saya akan coba yang mas pri kasih contoh...
thank u ya ----- Original Message ----- From: "Privida Kristiono" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, February 24, 2005 12:14 PM Subject: Re: [indo-oracle] HELP : FUll outer join > > column ambiguously, biasanya karena ada field yang ada > dikedua table (fsdprswc dan fsdpreqc), > sehingga membingungkan > jalan keluarnya tambahkan nama tabel di depan > namafield supaya jelas > masing-masing field diambil dari table mana > > terus saya mau tanya, klausa where yg digunakan apa > benar > fsdprswc.kode_barang = fsdpreqc.qty > sepertinya aneh kodebarang dibandingkan dengan qty > > jika anda menggunakan oracle 9 ke atas,anda bisa > menggunakan operator join dari oracle > > contoh > > select fsdprswc.kode_barang, fsdpreqc.qty > from fsdprswc Full Outer Join fsdpreqc > On fsdprswc.kode_barang = fsdpreqc.kode_barang > > > contoh > select fsdprswc.kode_barang,qty from > fsdprswc,fsdpreqc where fsdprswc.kode_barang = > fsdpreqc.qty (+) > > --- Handy Utama <[EMAIL PROTECTED]> > wrote: > > > 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] > > > > > > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail - You care about security. So do we. > http://promotions.yahoo.com/new_mail > > > -- > -----------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 > > > > > > > > --- This email server is protected by Clam AntiVirus (www.clamav.net) -- -----------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/
