UPDATE T1, T2, [INNER JOIN | LEFT JOIN] T1 ON T1.C1 = T2. C1 SET T1.C2 = T2.C2, T2.C3 = expr WHERE condition
update xtable x set col1 = y.col1 from ytable y where y.x_id = x.id;
select * from tableA a join tableB b on a.id like '%' + b.id + '%';