How do I update one field from another field in another table?


Create an Update Statment:

UPDATE IMInvLoc_Sql SET Price = (select ot.price from data.dbo.iminvloc_sql_Save OT where ot.item_no = iminvloc_sql.Item_no and ot.Item_filler=iminvloc_sql.item_filler and iminvloc_sql.loc=ot.loc)

This query updates the Price field of IMInvLoc_Sql to the Price field of IMInvLoc_Sql_Save (presumably a previous backup of the table)