title: Linq to Entity Framework: Multiple left outer joins create full outer
body: <p>I can't find a good example, probably I'm searching wrong:</p>
  
  <p>I have a bunch of tables joined via expression syntax and I'd like to left outer join two more, if there are values, otherwise return NULL.</p>
  
  <p>So the sql is looking like this:</p>
  
  <pre><code>select              *
  from                table1 mr
  left outer join     table2 on table1
  left outer join     table3 on table2
  left outer join     table4 on table3
  where               mr.id = 1234
  </code></pre>
  
  <p>So a left join is no problem with the syntax like this:</p>
  
  <pre><code>join oiA in query1 on organisation.Id equals oiA.Organisationid into qOrgInhA
  from oiA in qOrgInhA.DefaultIfEmpty()
  </code></pre>
  
  <p>But as soon as I add the other tables depending on the oiA, the Entity Framework produces a Cross-Join, and not a second left outer join.</p>
  
  <p>From what I've read, GroupJoin might be the solution, but I really can't find a good example, the most examples I found have just 2 tables.</p>
  
  <p>Or am I doing something totally wrong?</p>