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!).
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------