Re: Simple SQL Query
Date: Thu, 07 Jan 2010 18:10:38 +0100
A left outer join should do the trick reasonably well.
Pani Babu wrote:
> I have a simple SQL query which lists all the records that are not in
> a second table.
> select first.id <http://first.id> from first
> where first.id <http://first.id> not in (select id from second);
> As the second table is very huge, it takes a very long to process the
> Is there a way to rewrite the query to run it quicker?