Unmatched Query based on combo of two fields 1

[cdck]

I need to create a query that compares two fields in each of two tables, and determines which records in TableA do not exist in TableB based on the combination of those two fields. The Find Unmatched Query Wizard only allows you to compare single fields, so I'm not sure how to do this.

The tables are ActBud and CACworkCenters. The two fields to use are JobNumber and WorkCenter. for each JobNumber, there can be many WorkCenters, and vice-versa.

I need to import each JobNumber/WorkCenter combination from ActBud into CACworkCenters only if that combination is not already present in CACworkCenters. How can I write the SELECT section of the INSERT query to accomplish this?

Cheryl dc Kern

 

[PHV]

Have you tried this ?:
SELECT A.*
FROM ActBud A LEFT JOIN CACworkCenters C ON A.JobNumber = C.JobNumber AND A.WorkCenters = C.WorkCenters
WHERE C.JobNumber Is Null

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cdck]

That got it, thanks!

Cheryl dc Kern