update 结合查询更新

UPDATE a SET a.nstuId=b.bStuID FROM TableA a
INNER JOIN 
(
SELECT * FROM 
(
SELECT a.nTID,a.vcCtor, a.nStuID,isnull(b.nStuID,0) AS bStuID,a.dtCTime FROM Play_Task a 
LEFT JOIN 
(
SELECT b.vcOID,c.nStuID FROM 
mp_er b
INNER JOIN
T3_DR_Sc 
ON b.nUID = c.nUID
)b
ON a.vcCtor = b.vcID 
WHERE a.nStuID > 0 AND a.nStuID <> b.nStuID 
)a WHERE bStuID > 0 AND dtCTime > '2018-06-15' AND dtCreateTime < '2018-08-07'
) AS b
ON a.nTiD = b.nTiD

 

转载于:https://www.cnblogs.com/ghelement/p/9475514.html