摘要: 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 阅读全文