Find Duplicate Records from TWO different tables

[kendrad]

IS there a way to find Duplicate Records from two different tables? The Duplicate Query Wizard only allows for one table. I have a talbe of "Users" and a table of "Users who got new Laptops" I want to compare the two tables and find duplicate records so that I can find out if anyone on my "User" list has received a new Laptop.

Thank You,
Kendra

 

[Fornatian]

Use the unmatched query wizard and change Is Null to Not Is Null in the criteria row, this changes the unmatched query to a matched query.

 

[Pat Hartman]

A simple join between the tables will work. It will return only rows where the UserID exists in both tables.

 

[Fornatian]

Of course - thinking 2 deep