Update using lookup table question

[HPP]

How can I update values in a table with values in another table where values in a common field are equal in SQL Server 7? In Access the following code works, but not in sql server

UPDATE tbl1 INNER JOIN tbl2
ON tbl1.CommonField = tbl2.CommonField
SET tbl2.FieldToUpdate = tbl1.FieldContainingValue

 

[bperry]

Try it this way (untested):

UPDATE tbl2
SET tbl2.FieldToUpdate = tbl1.FieldContainingValue
from tbl2
INNER JOIN tbl1
ON tbl1.CommonField = tbl2.CommonField


bp