赞
踩
--UPDATE FROM UPDATE BasDeptInfo SET ManagerNo=table2.newno FROM BasDeptInfo,table2 WHERE ManagerNo=table2.oldno