Hi, I have two tables. Main table is soxbillingrelationship having a column as BRID along with many other columns. The other table is BR having just two columns one is BRID and other is OMS. Now i have to extract all the rows from the table BR which has BRID not existing in Soxbillingrelationship. I tried this query: select * from BR where BRID NOT IN (select brid from SoxBillingRelationship) order by BRID This is returning around 204 rows whereas totally there are more than 1000 BRID which are not in soxbillingrelationship table. Thanks for the advice!!