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.

CA,

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

--
Steve Schapel, Microsoft Access MVP


cabradley11 wrote:
> 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.

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