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 join dbo.UserInfo on ResidenceInfo.district=UserInfo.district
) T
where ResidenceInfo.id = T.rid
from
(
select ResidenceInfo.id as rid,
case when UserInfo.district is NULL then isrtuser else UserInfo.id end as newuser
from
dbo.ResidenceInfo left join dbo.UserInfo on ResidenceInfo.district=UserInfo.district
) T
where ResidenceInfo.id = T.rid