SELECT u.*,(select p.cityName from localCity p where p.cityId=u.cityId)as cityName FROM users u with(nolock) inner join (SELECT DISTINCT r.UserId,a.cityId FROM [RemedialUserRelation] r inner join [RemedialApplication] rp on r.ApplicationId = rp.id JOIN admin a ON rp.OperatorId=a.userid ) a ON u.userid=a.UserId