SqlServer批量更新两关联表的数据

Sql语句如下所示：

 

 1 --方式1
 2 UPDATE a SET WtNo=b.NO
 3 from WT_Task a
 4 INNER JOIN WT_BasicInformation b ON a.WtId=b.ID;
 5 
 6 --方式2
 7 UPDATE a SET a.WtNo=b.NO
 8 FROM WT_Task a,WT_BasicInformation b
 9 WHERE a.WtId=b.ID;
10