Update join table code example
Example 1: update with join
UPDATE
first_table ft
JOIN second_table st ON st.some_id = ft.some_id
JOIN third_table tt ON tt.some_id = st.some_id
.....
SET
ft.some_column = some_value
WHERE ft.some_column = 123456 AND st.some_column = 123456
Example 2: joins in update query
update a
join b
on a.a_id=b.b_id
set b.is_active = 1
where ....;