I have 2 tables with the same field names. How can I produce a query that displays all the dupes for table 1?
Fields: (in both tables)
Matnum, Subnum & Catnum
Only 1 field needs to match.
Created 3 queries - each have a one to one relationship (only include rows if both fields are equal)
(Display only table 1 values)
Matnum - Matnum
Subnum - Subnum
Catnum - Catnum
How can I include all these queries in one query or one listing/table with no dupes? (dupes meaning ID for table 1)
Or is there a better method?
Please be advised these tables are large (over 10K records).