comparing queries

  • Thread starter Thread starter Pitlochry1
  • Start date Start date
P

Pitlochry1

How do I run two queries and come up with records that are not duplicates?
 
SELECT f1, f2 FROM table1
UNION
SELECT g1, g2 FROM table2


would return no duplicated pair of fields from the merge of table1 and
table2, given fields. To GET the duplicated pairs, use UNION ALL instead of
UNION.


Vanderghast, Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine Duplicates in Query 0
Comparing Queries 1
Duplicate Values in Query 1
Comparing Query Results 2
duplicates query 2
Access Compare records in same access table 0
deleting duplicate records obtained from a duplicate query 4
Deleting duplicate records 3

Back
Top