title: join not returning all elements in left table C# lambda
body: <p>I have 2 tables, the left table has data like this:</p>
  
  <p><img src="https://i.stack.imgur.com/fYMok.jpg" alt="enter image description here"></p>
  
  <p>I do a left join with another table with the following expression:</p>
  
  <pre><code> var result = posicion.Join(fact,
                              p =&gt; p.Cod_articulo,
                              f =&gt; f.Cod_articulo,
                              (p, f) =&gt; new { p.Posicion, p.Cant_historico, 
                                              p.Cod_articulo, f.Cantidad_facturada });
  </code></pre>
  
  <p>The problem is that the results don't include some items from the left table as seen below:</p>
  
  <p><img src="https://i.stack.imgur.com/pgJIk.jpg" alt="enter image description here"></p>
  
  <p>As you can see in the result there is no data for position 3, 6 etc. what would be missing from my join?</p>