title: Multiple Select and Join with LINQ and Lambda
body: <p>How can I do this <code>query</code> using <code>LINQ and LAMBDA</code> ?</p>
  
  <p><strong>QUERY</strong>
  </p>
  
  <pre><code>Select san_negocio.imovel_id
        ,san_negocio.negocio_id
        ,san_imovel.credenciada_id
        ,san_proposta.proposta_id
        ,san_proposta.credenciada_id
    from san_negocio
    join san_proposta
      on san_negocio.imovel_id = san_proposta.imovel_id
    join san_imovel
      on san_negocio.imovel_id = san_imovel.imovel_id
   where san_negocio.credenciadacaptadora_id is null
     and san_negocio.credenciadavendedora_id is null
     and san_proposta.statusproposta_id = 2
  </code></pre>
  
  <p><strong>I've tried:</strong></p>
  
  <pre><code>var objetos = db.San_Negocio.Join(db.San_Proposta, a =&gt; a.Imovel_Id, b =&gt; b.Imovel_Id, (a, b) =&gt; new { San_Negocio = a, San_Proposta = b })                
      .Join(db.San_Imovel, a =&gt; a.San_Negocio.Imovel_Id, c =&gt; c.Imovel_Id, (a, c) =&gt; new { San_Negocio = a, San_Imovel = c })
      .Where(a =&gt; a.San_Negocio.San_Negocio.CredenciadaCaptadora_Id == null &amp;&amp; a.San_Negocio.San_Negocio.CredenciadaVendedora_Id == null)
      .Select(a =&gt; new { a.San_Negocio.San_Negocio.Negocio_Id, 
              a.San_Negocio.San_Negocio.Imovel_Id, 
              a.San_Imovel.Credenciada_Id });
  </code></pre>
  
  <p>My doubt is in my <code>Select</code>. How can I call my <code>San_Proposta</code> table ?</p>