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