Update one table with another table?

  • Thread starter Thread starter Burger King
  • Start date Start date
B

Burger King

Hello

I have one main table with about 10000 records and I am
trying to update only about 2000 from a different, updated
table some temp created before he left. How can I update
this information from one table to another? Both have
ID's as primary keys, both have the same ID for the same
client, I tried the update query and all that but to no
avail... Any assistance would be appreciated!
 
****Untested****
UPDATE T1 INNER JOIN T2 ON T1.[ID] = T2.[ID]
SET T1.Field1 = T2.Field1, T1.Field2 = T2.Field2
....

The Inner Join will update only those Records in T1 that have matching
Records in T2.
 
Back
Top