title: Mysql join query help, not working as required
body: <p>I want to get all table records from table_1 and Username from table_2 by joining with userID from table_1</p>
  
  <p>"UserID save in table_1, column name msg_from"</p>
  
  <p>Below query fetching only one record by user. Please help me to get all messages.</p>
  
  <pre><code>SELECT t1.id, t1.subject, t1.msg_from, t1.msg_date, t1.msg_status, t2.username
  FROM table_1 AS t1, table_2 AS t2
  WHERE t2.id = t1.msg_from
  </code></pre>