Update t1 Set t1.col1=t2.col2 From t1 as t Join t2 as tt On t.id=tt.fid Where....

Update t1
Set t1.col1=t2.col2
From t1 as t
Join t2 as tt
On t.id=tt.fid
Where....