For the record, here is a complete example of the UPDATE ... JOIN syntax that I
posted earlier. This from one of my current projects.

UPDATE CD
SET
C_ACCEXEC=AE.C_ACCEXEC
FROM Customer_Details CD
JOIN AccountExec AE ON (CD.C_ACCEXEC=AE.Name OR CD.C_ACCEXEC=AE.Name+' 2')
Note the use of the keyword FROM to denote the table which is being updated.

I hope this finally helps.

Regards,
Morpheus

"See how deep the rabbit hole goes...."