sql server - SQL update query syntax with inner join - Stack Overflow

The SET needs to come before the FROM\JOIN\WHERE portion of the query. UPDATE CE SET sJobNumber = AD.JobNumber FROM CostEntry CE ...

stackoverflow.com