摘要： update ResidenceInfo set isrtuser = T.newuser from ( select ResidenceInfo.id as rid, case when UserInfo.district is NULL then isrtuser else UserInfo.id end as newuser from dbo.ResidenceInfo left j... 阅读全文