NOT IN queries
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
Subject
Written By
Posted
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.