title: How to change my query with LEFT JOIN
body: <p>I have this query</p>
  
  <pre><code>SELECT N.CodOperazione,DataOperazione,N.Descrizione,Imponibile,Iva,
  Totale,CA.CodConto,TotalePubblico 
  FROM NotaSpese N LEFT JOIN  Conti CA ON(N.CODCONTO = CA.CodConto) 
  LEFT JOIN CONTI_BANCARI_X_OPERAZIONI CO ON (N.CodOperazione = CO.ID_SPESA) 
  INNER JOIN CONTI_BANCARI C ON (CO.ID_CONTOBANCARIO = C.ID)  AND C.Tipologia_Conto ='Pubblico'  
  ORDER BY DataOperazione DESC
  </code></pre>
  
  <p>I want to know the all record into NOtaSpese Table also if there aren't any record in the others tables.
  I have any records into NotaSpese table, but the query have an empty set</p>
  
  <blockquote>
    <p>EDIT
    I think the error is in this point</p>
  </blockquote>
  
  <pre><code>C.Tipologia_Conto ='Pubblico'
  </code></pre>
  
  <p>because if I remove it, the result set is not empty</p>