Merging data - no duplicates

C

Carlee

Hi,

I have two tables with Owner information in each. I want to create a single
data set, without duplicates.
Can anyone suggest an approach?
 
M

Michel Walsh

Hi,


TABLE tableName1
UNION
TABLE tableName2



If you want all the records, use UNION ALL instead of UNION



Hoping it may help,
Vanderghast, Access MVP
 
Top