用表A的数据更新表B的数据

用表A的数据更新表B的数据
update A  ta
set ta.col1 =
(
select col1 from B tb
where ta.id = tb.id
)
where
ta.id in (select tc.id from C tc)