Hello,<BR><BR>I have 2 tables. I need to check if there are any records which exists in table_a but are not in table_b. Could you help me with the syntax? The database is MS Access.
Select Tableb.Id, Tablea.Id From Tablea LEFT JOIN Tableb ON Tablea.Id = Tableb.Id WHERE Tableb.Id is Null