Comparison Query with mismatched columns

[June7]

Another way to say it - you want to find records in MRP that are not already in Master.



What is LEFT JOIN pulling - Should be "Retrieve all records from MRP and only those from Master that match". Then need Is Null criteria under the Master fields for a Find Unmatched result.

The 'extra' fields are in MRP? They should be retrieved by the query you posted.

[gaker10]

The extra columns are in Master. So where in my code should I put that?

SELECT MRP.*, Master.extrainfo1, Master.extrainfo2, Master.extrainfo3, Master.extrainfo4
FROM MRP LEFT JOIN Master ON (MRP.ShipDate = Master.ShipDate) AND (MRP.DatePromised = Master.DatePromised) AND (MRP.QtyOrdered = Master.QtyOrdered) AND (MRP.CustLine = Master.CustLine) AND (MRP.ClassCode = Master.ClassCode) AND (MRP.CustPO = Master.CustPO) AND (MRP.CustID = Master.CustID) AND (MRP.SOLine = Master.SOLine) AND (MRP.SONumber = Master.SONumber) AND (MRP.PartNumber = Master.PartNumber)
WHERE (((Master.PartNumber) Is Null));

[June7]

You don't put the 'Retrieve ...' in the sql statement. That was a description of the JOIN type. It will be either a LEFT or RIGHT (I never can remember which way). I see you have LEFT. In query design view, click on the link line between the two tables and see what the selected join description is.