Mungkin bisa di coba dengan query seperti ini UPDATE PEL SET IDPEL = (SELECT IDPLGN FROM IDPEL WHERE pel.KDPEL = CKDPEL); Semoga membantu -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Fir3 [EMAIL PROTECTED] Sent: Wednesday, April 12, 2006 9:00 AM To: [email protected] Subject: Re: [indo-oracle] Query SQL Tanda "=" di (UPDATE PEL SET IDPEL = ) menunjukan perbandingannya dengan hanya satu data. Sedangkan hasil dari (SELECT IDPLGN FROM IDPEL) WHERE KDPEL IN (SELECT CKDPEL FROM IDPEL); lebih dari satu data, jadi syntaqnya tidak bisa seprti itu. Semoga menbantu.
Wasalam ----- Original Message ----- From: "Hendra" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Saturday, April 08, 2006 6:28 PM Subject: [indo-oracle] Query SQL > Salam Kenal... > sebagai anggota baru di milis ini, maaf kalo sedikit merepotkan.. > saya orang yang baru belajar oracle. > karena itu saya seidikit membutuhkan bantuan, terutama tentang query > sqlnya. > begini saya ingin mengupdate, idpelangan di sebuah tabel. idpelanggan > baru itu berada di tabel lain... > kurang lebihnya saya mencoba query seperti dibawah ini : > > UPDATE PEL SET IDPEL = (SELECT IDPLGN FROM IDPEL) WHERE KDPEL IN > (SELECT CKDPEL FROM IDPEL); > > tapi kok ada muncul statement dibawah ini : > "single-row subquery return more than one row" > > mohon pencerahannya.... > dan terima kasih atas bantuannya.. > > > > > > > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com _____ YAHOO! GROUPS LINKS * Visit your group "indo-oracle <http://groups.yahoo.com/group/indo-oracle> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! <http://docs.yahoo.com/info/terms/> Terms of Service. _____ [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.lizt.org (NEW) ----------------------------------------------- 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/
