sqlserver通过两表或多表关联批量更新

UPDATE a SET a.WtNo=b.NO 
FROM WT_Task a,WT_BasicInformation b 
WHERE a.WtId=b.ID;