MySQL :: MySQL 5.0 Reference Manual :: 13.2.10 UPDATE Syntax

Update column in a table whose values are not found in another table. UPDATE TABLE_1 LEFT JOIN TABLE_2 ...

dev.mysql.com