title: Linq - How to construct this query without the 'join' keyword?
body: <p>I have the following partial Linq query:</p>
  
  <pre><code>var query = from ri in RouteInstance
          join rir in RouteInstanceRules on ri.RouteInstanceID equals rir.RouteInstanceID
          join rl in RoutingLocation on rir.RoutingLocationID equals rl.RoutingLocationID
          join rlh in RoutingLocationHistory on rl.RoutingLocationID equals rlh.RoutingLocationID
          where rlh.RouteTakenTime &gt;= new System.DateTime(2011,2,4) &amp;&amp; rlh.RouteTakenTime &lt;= new System.DateTime(2011,2,5)
  
  There is a 1:M relationship between RouteInstance and RouteInstanceRules
  There is a 1:M relationship between RouteInstanceRules and RoutingLocation
  There is a 1:M relationship between RoutingLocation and RoutingLocationHistory
  </code></pre>
  
  <p>Since these relationships are enforced using FKs and are therefore known to L2S, I should be able to construct this query without using the 'join' keyword. But, I am stumped as to how to do it.</p>
  
  <p>Thanks.</p>