How to combine two tables and dedup records from one table

[Guest]

I'm trying to combine two tables of like data and end up with unique records
from one of the tables. In essence, place one set of data over the other and
end up with the unique difference from the one table but not have the unique
records from the other. Is this even possible.

 

[Steve Schapel]

CA,

Are you able to give an example of what you want? Might make it easier
to understand.

 

[arthurjr07]

SELECT * FROM Table1
UNION
SELECT * FROM Table2 where Field1 not in ( Select Distinct Field1 From
Table1)