Re: SQL subquery question

try: select * from a where not exists (select * from b where b.x=a.x and b.y=a.y) HTH Doug Geoffrey Poole wrote in message <7hc5vo$5om$1@news.xmission.com>... > >What is the easiest way to write the following SQL :- > >select * from a where (x,y) not in (select x,y from b);> >I've a foreign key constraint on 2 columns that has failed to build so >I'm trying to find the offending rows. >Geoff Poole >geoffrey.poole@ogs.co.uk >