mysql – UPDATE xxxx INNER JOIN

Aktualizuje rekordy powiązane z inną tabelą

UPDATE projects p
 INNER JOIN companies c ON c.id=p.company_id
SET p.manager_id = c.manager_id
WHERE c.manager_id <> p.manager_id
 AND (p.prev_manager_id <> p.manager_id OR p.prev_manager_id IS NULL);
 AND c.manager_id = 1023;