title: Outer join in LINQ Problem
body: <p>Id like to perform an outer join with the second join statement in this query, I keep getting weird errors! (it must be the 3rd RedBull)</p>
  
  <pre><code>var Objeto = from t in Table1.All()
               join su in table2.All() on t.Id equals su.Id
               join tab2 in Table1.All() on t.PId equals tab2.Id //&lt;-I want it here
               select new
               {
                   t.Field1,
                   SN = su.Field123,
                   PTN = tab2.FieldABC
                };
  </code></pre>
  
  <p>Any help would be appreciated.</p>
  
  <p>[Edit] - I neglected to say that I'm using SubSonic 3.0, the bug seems to be with SubSonic.....</p>