Merging data - no duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top