SqlServer Update关联多表

--1.批量更改语句

Update  t1 set t1.field1=t2.field1  from tab1 t1 
inner join table2 t2 
on t1.field2=t2.field2