title: List all mysql records in a master table and last record in a related child table
body: <p>I want to list all  records in a mysql master table and only the last record in the related child table. Here is the code. But it outputs only the matched records for two tables of PK. Not lists the rest of records in the master</p>
  
  <pre><code>SELECT contact.id, contact.title, contact.init, contact.first_name, contact.last_name, contact.city, contact.home_phone, contact.mobile_phone, contact.e_mail,  status.status AS status, fundsource.fundsource AS fundsource, category.category AS category,contact.score, ROUND(value/1000000,1) AS value_M, jstate.jstate AS to_do, journal.l_date AS last_activity, journal.note AS journal FROM contact 
  
      LEFT JOIN journal ON journal.con_id=contact.id 
      LEFT JOIN jstate ON jstate.jstate_code=journal.jstate_code
      LEFT JOIN category ON category.cat_code=contact.cat_code
      LEFT JOIN status ON status.st_code=contact.st_code
      LEFT JOIN fundsource ON fundsource.fundsource_code=contact.fundsource_code 
  
      WHERE journal.l_date=(SELECT MAX(journal.l_date) from journal WHERE journal.con_id = contact.id) GROUP BY contact.id 
  </code></pre>
  
  <p>Can anyone help me? Pls</p>