var result = from u in this.DataContext.Users
         join l in DataContext.Locations on u.Id equals l.userId
         where
            u.active == 1
         select u;
return result ;

where u.Id in (SELECT userId from approved_users)