Joined: 15 Jun 2005
|Posted: Wed Jun 15, 2005 1:11 am Post subject: Query: update fields in a table using another (Beginner's Q)
|Hi, hope you don't mind a beginners question
on the Query window.
I'm looking for the best way to update the data in one table
using data from another table. (Table 1 is a MS Access table
connected via ODBC)
This is the setup:
Table 1 has the fields
ID, Name, Name2, Content, morefields
Table 2 has the fields
differentID, Name, Name2, Content
I would like to update the "Content" field in table 1 with
same field in table 2 whenever Name and Name2 both match.
In case there's more than one match I do not care which value
While I can do a query that displays the result the way I want,
I have not found out how to change values using a query.