title: LEFT JOIN SQLite
body: <p>I'm having problems when making a left join with SQLite. </p>
  
  <p>structure of the tables</p>
  
  <pre><code>contacts: id_c, first_name, last_name, photo_link
  messages: id_msg, id_sender, id_recipient, utimestamp, message, chatID
  </code></pre>
  
  <p>I'm doing a query as follows:</p>
  
  <pre><code>SELECT * FROM messages m 
    LEFT OUTER JOIN contacts c ON (c.id_c=m.id_sender) 
    WHERE m.chatID=26
  </code></pre>
  
  <p>This query returns values ​​from the message table.<br>
  But returns null for the contacts table.</p>
  
  <p>I tried several ways and can not resolve this problem. Any suggestions to solve this?</p>