In multiple table UPDATE, it updates rows in each specified tables that satisfy the conditions. Each matching row is updated once, even if it matches the conditions multiple times.
In multiple table UPDATE, ORDER BY and LIMIT cannot be used.
Syntax for multi table UPDATE is,
UPDATE [LOW_PRIORITY]...