Update with inner join 2

[jimmyshoes]

I am trying to combine the update statement with an inner join

Update Table1 INNER JOIN Table2
On table1Col = table2Col
SET somefield = 'New Name'

(Both tables have unique field names so I have not used AS )

I am getting the error 'Incorrect syntax near the keyword 'INNER'.'

 

[bborissov]

Update Table1 SET somefield = 'New Name'
FROM Table1
INNER JOIN Table2 On table1Col = table2Col

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[jimmyshoes]

If someFieldTable1 is a field in Table1 and someFieldTable2 is a field in Table2, is it possible to modify the above code to set someFieldTable1 to 'newValueFor1' and someFieldTable2 to 'newValueFor2'

 

[markros]

No, the UPDATE statement can only update one table at a time in SQL Server.