SQLServer联合查询更新表数据

UPDATE a SET WtNo=b.NO
from WT_Task a
INNER JOIN WT_BasicInformation b ON a.WtId=b.ID;

update a set a.ProjectID=b.ProjectID from
[ICTR_Project_NoticeSubkey] a,[iCTR_Project_Projects] b 
where a.ParentProjectID=b.ParentProjectID
and a.zt=2