Thursday, January 11, 2007

The SQL "NOT IN" clause becomes
SELECT * FROM Sheet2 AS U
WHERE (((Exists (SELECT f2 FROM Sheet2 AS B WHERE B.f2 = U.f1))=False));

or
SELECT * FROM Sheet2 AS U
WHERE NOT EXISTS (SELECT f2 FROM Sheet2 AS B WHERE B.f2 = U.f1);