title: linq-to-sql joins with multiple from clauses syntax vs. traditional join syntax
body: <p>What the difference between writing a join using 2 <code>from</code> clauses and a <code>where</code> like this:</p>
  
  <pre><code>var SomeQuery = from a in MyDC.Table1
                  from b in MyDC.Table2
                  where a.SomeCol1 == SomeParameter &amp;&amp; a.SomeCol2 === b.SomeCol1
  </code></pre>
  
  <p>and writing a <code>join</code> using the join operator.</p>
  
  <p>This is for a <code>join</code> on 2 tables but of course, sometimes, we need to join even more tables and we need to combine other <code>from</code> clauses with <code>where</code> if we choose the syntax above.</p>
  
  <p>I know both syntax queries return the same data but I was wondering if there's a performance difference, or another kind of difference, that would conclusively favor one syntax over the other. </p>
  
  <p>Thanks for your suggestions.</p>