title: mysql left join and order by
body: <p>hi i have to different tables m_mp and m_answer
  both have m_date and m_mdate which fills with time() function i want to select both entries but order by date</p>
  
  <p>example:</p>
  
  <p>first table: 'some text','6464647776'
  second table 'some answer','545454545'</p>
  
  <p>so i want to show first second table and then the first one</p>
  
  <p>this is the code im using:</p>
  
  <pre><code>SELECT r.*,u.* 
  FROM `mensajes` as r 
  LEFT JOIN `m_answer` as u on r.id = u.id_m 
  WHERE r.id  = '1' 
  ORDER BY m_date
  </code></pre>
  
  <p>and then display the result of each table using while-loop</p>