How do I get all the rows in one table that are not in another in MS Access?
NOT IN version (slow but sure):
SELECT con_numberFROM TableBWHERE con_number NOT IN (SELECT con_number FROM tableA);
experimental version (don't know if this is any faster, just try it out):
SELECT B.con_number, MAX(A.con_number) AS checkFROM tableB B LEFT JOIN tableA A ON B.con_number = A.con_numberGROUP BY B.con_numberHAVING check IS NULL;
Note: Both should be fairly standard SQL, I don't know any ms-access specific features