P Pitlochry1 Feb 9, 2009 #1 How do I run two queries and come up with records that are not duplicates?
M Michel Walsh Feb 11, 2009 #2 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
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
