I have two table tblA and tblB. tblB was made by selecting distinct First and Last name from tblA.
So tblB has 500 rows and tblA has 800 rows. Now I want to add the Country of birth to tblB with an update query joining tblA and tblB on first and last name.
Already you can see the conflict, there might be multiple values in tblA destined for one row in tblB.
When I run the update Access tells me I am about to update 800 rows, but really it is only updating the 500 rows in tblB.
What is really going on under the hood here, and what is a better way to do this operation?
So tblB has 500 rows and tblA has 800 rows. Now I want to add the Country of birth to tblB with an update query joining tblA and tblB on first and last name.
Already you can see the conflict, there might be multiple values in tblA destined for one row in tblB.
When I run the update Access tells me I am about to update 800 rows, but really it is only updating the 500 rows in tblB.
What is really going on under the hood here, and what is a better way to do this operation?