shadow9449
Registered User.
- Local time
- Yesterday, 21:02
- Joined
- Mar 5, 2004
- Messages
- 1,037
It's a common practice to use an update query to update a field in one table (let's call it Table1) based on joining a field in another table (let's call it table 2) and then retrieving a value from Table2 based on matching the keys and updating a row in Table1.
My question is: what if more than one row of Table2 meets the criteria of the join?
In other words, Table1 only has one row to update, but there are several possibilities in Table2 based on the join we created. How does Access decide which value to update the field on Table1 with?
In a Select query, what happens is the query will return all matching rows in Table2. However, an update query can only update the field once.
Thank you
SHADOW
My question is: what if more than one row of Table2 meets the criteria of the join?
In other words, Table1 only has one row to update, but there are several possibilities in Table2 based on the join we created. How does Access decide which value to update the field on Table1 with?
In a Select query, what happens is the query will return all matching rows in Table2. However, an update query can only update the field once.
Thank you
SHADOW