UNION Statement Allowed Duplicate in my Primary Key

[vetabz]

Hi,



I have a Union statement combing two tables with similar fields - this should eliminate duplicate row and it did. However, I see duplicate numbers in my Primary Keys... How should I prevent that?

I simply did a

Select * From Table1 UNION Select * From Table2.

[JoeM]

A union query is not a table, so table rules, such as Primary Keys, do not apply.
Is every single field a duplicate?
If not, what is the logic for which record to keep and which one to drop?

What exactly are you trying to accomplish?
It might be helpful if you could post some samples of data from each table and your expected results.

[NTC]

to add to JoeM: the short answer is you cannot if you use the * symbol - - you would have to not include the Primary Key field in the query so instead of * as a short cut for all, instead specify each field and don't include the Primary Key field.

[vetabz]

Thanks for clearing that out "A union query is not a table, so table rules, such as Primary Keys, do not apply."

I'm pretty much contended with that statement alone.

[JoeM]

If you are just trying to combine the two tables into one, you can do an unmatched query to find all the records from Table2 that are not in Table1, then do an Append Query of those records to write them to Table1.