CODE EXAMPLE FOR SQL

joins in update query

update a
join b 
on a.a_id=b.b_id 
set b.is_active = 1 
where ....;