I have Table1 with FieldA and Table2 with FieldA. I would like to query Table1 for all records that DO NOT exist in FieldA of Table2. I have tried the following but it doesn't filter correctly. Any suggestions?? Thx!! SELECT Table1.FieldA FROM Table1, Table2 WHERE Table1.FieldA <> Table2.Field

I'm not real good with SQL, but I think the solution would be to join the two tables (inner or outer?) such that every record in tableA would have it's corresponding value from B as well. Then put in your where clause that you only want records where the B value is null. This probably isn't right, but it should be the right direction: SELECT Table1.FieldA as field1, Table2.FieldA as field2 FROM Table1, Table2 WHERE Table1.FieldA=Table2.FieldA AND field2 IS NULL Michael J

SELECT TABLE1.ID, TABLE2.ID FROM TABLE1 LEFT JOIN TABLE2 ON TABLE1.ID = TABLE2.ID WHERE (((TABLE2.ID) Is Null));

Try this SELECT Table1.FieldA FROM Table1 WHERE Table1.FieldA NOT in ( select Table2.FieldA from Table2 )

Both mdow and babaji have correct solutions (And Michael, except the join should be a left join as mdow suggested) , but mdow's will be much, much faster. You should avoid having subqueries in the WHERE statement whenever possible. Good luck, -SN

As I said, I didn't think my structure was quite right, but I was pretty sure of the logic behind it. Michael J