Update field based on another field in another table 1

[Corr]

Hello,

Here it goes. I have two tables: TableA and TableB. Both tables have a field named Inv_Part_Key that is the same on both tables as well as a field called Notes. The Notes field in TableA has data while TableB does not.

How can I get the data from TableA, Notes to update TableB, Notes by updating the proper rows with the proper data. I am assuming I would have to use a field that can be used as an identifier, so I included the column Inv_Part_Key.

Please let me know if more info is needed.

Thank You,

John

 

[Zathras]

See my post in thread183-443892.

 

[cheyney]

Use the UPDATE..FROM construct, like this:


UPDATE TableB
SET TableB.Notes = TableA.Notes
FROM TableA
WHERE TableB.Inv_Part_Key = TableA.Inv_Part_Key

Cheyney