Re: SQL subquery question
Geoffrey
How about
SELECT a.*
FROM a, OUTER b
WHERE b.x IS NULL
AND b.y IS NULL
HTH
Sujit
Geoffrey Poole <Geoffrey.Poole@ogs.co.uk> on 05/12/99 08:04:23 AM
To: informix-list@iiug.org
cc: (bcc: Sujit Pal)
Subject: SQL subquery question
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