MySQL Forums
Forum List  »  Perl

NOT IN queries
Posted by: satish singh
Date: September 14, 2010 03:02AM

I want to query a table"ONE" which has around 2 lakhs of record with primary key as ID1(integer) second table contans only ID2 having values same as table one ID1 but some are not available in Table"two".Now I want those rows of table "one" whose ID1 are not available in table "Two" ID2.

I tried this

select ID1 from one where ID1 not in(select ID2 from two) order by ID1;

but query hangs up on the server and does not provide any reultset

Options: ReplyQuote

Written By
NOT IN queries
September 14, 2010 03:02AM
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.