coba ganti "not in" dengan "not exists", dan ganti tanda * dengan
menyebutkan nama fieldnya..
contoh :
select t.a, t.b, t.c
from trdbom t
where not exists (
select y.part_no
from titmsp y
where t.child_part=y.part_no)
silahkan dcoba dulu..
ace.
--- In [email protected], "Reichkanzler Gugun"
<[EMAIL PROTECTED]> wrote:
>
> 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
<*> 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/
