Unmatched Query on Multiple Columns?

[riggsd]

I need to compare two tables and find the records that don't match. The first table is from a query run on the Access database and saved to a table. The second table is from a report extracted from an Oracle database then imported into a table in the Access database.

I tried the unmatched query wizard, but it only allows you to check on one column. For my purposes, I need all three columns in each table to match exactly.

Can the unmatched query be modified to do this and if so, how would this be done?

 

[ByteMyzer]

For unmatched query scenario involving multiple columns, the following structure is recommended. For this example, we will look in Table1 for records which do not have related records in Table2, using Field1, Field2 and Field3 for our matching columns:

SELECT Table1.*
FROM Table1 LEFT JOIN Table2
ON Table1.Field1=Table2.Field1
AND Table1.Field2=Table2.Field2
AND Table1.Field3=Table2.Field3
WHERE Table2.Field1 Is Null;

See if this works for you.

 

[riggsd]

Yes, thank you very much.

 

[Pat Hartman]

There are several places where the Access wizards are limited. Once the wizard has built the basic query (or whatever), you can then modify it.

 

[riggsd]

Yes, I realize that. I just didn't know how to modify it for this instance. I appreciate the assistance.