Re: SQL question: checking all required items

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
---------------------------------------------------------------