Re: NOT IN queries

[Randy Clamons]

Try this (It's the older method without sub-queries):

select ID1
from one
left outer join two on ID1 = ID2
where ID2 IS NULL

I assume two is indexed on ID2.