MySQL / JOINを使ったUPDATE文

UPDATE
    table_a
INNER JOIN table_b ON (table_a.b_id = table_b.id)
SET
    table_a.a_name = table_b.b_name
WHERE
    1