SQL多表关联更新

T-SQL

//方法1

UPDATE UIT SET UIT.InnerID = UAT.InnerID
FROM UserMgr_UserAccount_SchoolLeader AS UAT INNER JOIN UserMgr_UserInfo_SchoolLeader AS UIT 
ON UAT.UserID = UIT.UserID

 

//方法2

UPDATE UIT
SET UIT.InnerID = UAT.InnerID
FROM UserMgr_UserAccount_SchoolLeader AS UAT,UserMgr_UserInfo_SchoolLeader AS UIT
WHERE UAT.UserID = UIT.UserID