sql - update table with join

-- 2 related tables

update t1
set t1.Field = t2.Field
from Table1 t1
join Table2 t2 on t1.id = t2.id

-- 3 related tables


update t1 p
set t1.f1 =
(
select distinct t3.f3
from t3
inner join t2 on t2.f2 = t3.f3
where t2.f2 = t1.f1
order by t3.f3
)