title: How to perform left join using lambda
body: <p>What would be the lambda equivalent of the following SQL query:</p>
  
  <pre><code>  select a.name, s.color from table1 a
    left join [table2] s
    on a.id = s.id 
  </code></pre>