On 8/10/07, Raymond O'Donnell <rod@iol.ie> wrote:
> On 10/08/2007 21:29, Scott Marlowe wrote:
>
>
> > select table1.id from table1 where table1.id is not in (select id from table2);
>
> Duh! I should have thought of that.... thanks for that, and apologies
> for the stupidity (blame it on the glass of wine I had with dinner!).
It's only obvious after you've done it a few times...
Show us the query when you're done, I'm sure there are enough folks
who'd like to see your solution.