Access 2000 Union

[cribby]

I have two tables with phone numbers that I need to merge together. However the phone books are different lenghts and will have duplicate numbers. I need to get this down to one phone book without duplicate numbers. I did a UNION, however it still shows the duplicate numbers. Is it possible to delete the dup's in the union query?

 

[Geoff Codd]

try and run a find duplicates query on the union query