Bisa dicoba dengan query berikut: select * from trdbom t1 where not exists (select 'x' from titmsp t2 where t1.child_part = t2.part_no);
Salam, Indra Armansyah [EMAIL PROTECTED] ----- Original Message ----- From: "Reichkanzler Gugun" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, August 25, 2006 9:33 AM Subject: [indo-oracle] TANYA OPTIMIZE QUERY > Para suhu2 SQL help me dunk.. > > saya ada kasus > saya ingin mengquery 2 tabel dengan menggunakan NOT IN dengan cara ini > bisa tapi agak lama sekali, karena datanya cukup banyak > > query yg saya pakai > select * from trdbom t > where child_part NOT IN ( select part_no from titmsp ) > > ada cara lain tidak selain yg diatas supaya lebih cepat .. > > > > atas bantuannya > > thx (gugun) > > > > ______________________________________________________________________ > This email has been scanned by the MessageLabs Email Security System. > For more information please visit http://www.messagelabs.com/email > ______________________________________________________________________ > > [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 > > > > > > > > > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.405 / Virus Database: 268.11.6/427 - Release Date: 8/24/2006 > > -- -----------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/ <*> 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/
