MySQL Forums
Forum List  »  Perl

Re: NOT IN queries
Posted by: Randy Clamons
Date: September 14, 2010 12:12PM

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.

Options: ReplyQuote

Written By
September 14, 2010 03:02AM
Re: NOT IN queries
September 14, 2010 12:12PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.