UIT SET UIT.InnerID = UAT.InnerID
FROM UserMgr_UserAccount_SchoolLeader AS UAT INNERJOIN 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