当前位置:Gxlcms > 数据库问题 > SQL多表关联更新

SQL多表关联更新

时间:2021-07-01 10:21:17 帮助过:10人阅读

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

 

SQL多表关联更新

标签:inner   nbsp   多表关联   rac   where   span   from   div   date   

人气教程排行