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
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