UpDate Query

A

Adam

How do I create an Update query gets data from table 'A' that has 18 updated fields and overwrite the 18 fields in table 'B'. Table 'B' has many for fields that the 18, so I don't want to change any of the information in the other fields
Please help
Thank you!!!
 
J

John Spencer (MVP)

UPDATE TableA as A INNER JOIN TableB As B
ON A.SomeIDField = B.SomeMatchingIDField
SET B.Field1 = A.Field1,
B.Field2 = A.Field2,
B.Field3 = A.Field3,
B.Field4 = A.Field4,
...
B.Field18 = A.Field18

That assumes that there is some way to match the records in the two tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Update Progress Information and Reschedule work for all Tasks - Project 2003 0
Adding data to MS Access from csv file 0
How to have two tables on same line? 1
Problem activating pre-installed MS Office home and Student 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Footnote references on one page, footnote text on the next 5
sqlite-odbc write conflict 2

Top