UPDATE A
SET STDCOST = B.Cost
FROM Table_A A, Table_B B WHERE
A.ITEM = B.Item AND A.Location = B.Location;