update statement in sql with joins code example

Example: joins in update query

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