title: More than 2 tables JOIN in LINQ, scope issue
body: <p>I am trying to join 3 table in LINQ.</p>
  
  <pre><code>var fromCities = from c in cityRepository.Cities
                               join r in routeRepository.Routes on c.Id equals r.FromCityId
                               join cr in rentDetailRepository.CarRentDetails on cr.CityId equals c.Id
                               select c;
  </code></pre>
  
  <p>I am getting that cr and c do not exist in the second join statement?
  Could somebody help?</p>