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);
Thursday, January 11, 2007
Subscribe to:
Posts (Atom)