How to select the complement of two tables with composite primary keys

[desgordon]

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:

    
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.

[Robeen]

See if this works:

Select * From table1 Where NOT EXISTS
(Select table2.primary_key_field From table2 Where table1.primary_key_field = table2.primary_key_field);