Append Query keeps duplicating records

[AlexTheGr8]

Hi All,



I have UpdateTable which holds provider names, the year they signed on, and their unique IDs (but not a primary key) that I want to append to an existing table (OperationalReviews). There are about 700 records.

When I write the append query it ends up appending 2100 records instead. Essentially each row is repeated three times and I'm not sure why. I've pasted the SQL below. Is there any way to make it so that the table appends as is and doesn't repeat itself?

INSERT INTO OperationalReviews ( ProviderID, Provider, OpReviewYear )
SELECT UpdateTable.F1, UpdateTable.F2, UpdateTable.F3
FROM UpdateTable, OperationalReviews;

Any feedback is welcome!

Thanks,
AlexTheGr8

[pbaldy]

The lack of join creates a Cartesian product, and you don't use the second table anyway. Try

INSERT INTO OperationalReviews ( ProviderID, Provider, OpReviewYear )
SELECT UpdateTable.F1, UpdateTable.F2, UpdateTable.F3
FROM UpdateTable

[AlexTheGr8]

This solved my issue - thank you so much!

[pbaldy]

Happy to help!