I have two tables that have identical schema and one table has a subset of the data that exist in the other. I want to select the data from the first table (table1 say) that does not exist in the other (table 2) using a query of the form:
Code:
select * from table1 where Primary_key_field not in (select primary_key_field from table2)
My problem is that primary_key_field is not a single field but is a combination of three other fields.
My question is whether in MS Access it is possible to do the query using a composite primary key field.