title: Left join multiple tables using lambda expression
body: <p>I have 2 tables:</p>
  
  <blockquote>
    <p>specs {specId, desc, createdby, lastupdatedby}<br>
    users {userid, username}</p>
  </blockquote>
  
  <p>I want the below linq query need to be written in pure lambda expression</p>
  
  <pre><code>    from spec in specs
      from user in users.where(x =&gt; x.userId== spec.createdby).DefaultIfEmpty()
      from updatedUser in users.where(x =&gt; x.userId== spec.lastupdatedbyby).DefaultIfEmpty()
  select new {
  spec = spec
  user = user,
  updatedUser = updatedUser
  }
  </code></pre>
  
  <p>Please assist.</p>
  
  <p>Data would be like say:</p>
  
  <pre><code>spec[{1, test, 1234, 2345},{2, test1, 1234, null}]
  
  users[{1234, Allen},{2345, Dwayne}]
  </code></pre>
  
  <p>So the result should be </p>
  
  <pre><code>[{1, test, Allen, Dwayne}, {2, test1, Allen, null}]
  </code></pre>