title: MYSQL select from 3 or more tables
body: <p>I need to make a MySQL query to show data from 3 diferents tables.</p>
  
  <p>This is the table 1:</p>
  
  <p>TABLE1</p>
  
  <ul>
  <li><p>id</p></li>
  <li><p>reference</p></li>
  <li><p>name</p></li>
  <li><p>email</p></li>
  </ul>
  
  <p>This is the table 2:</p>
  
  <p>TABLE2:</p>
  
  <ul>
  <li><p>id</p></li>
  <li><p>phone</p></li>
  </ul>
  
  <p>This is the table 3:</p>
  
  <p>TABLE3:</p>
  
  <ul>
  <li><p>id</p></li>
  <li><p>phone</p></li>
  </ul>
  
  <p>I need to show all data from table1, and also the phone from table2 or table3, only if the id in table2 or table3 is the same number that is in the reference field in table1.</p>
  
  <p>Any advice? Thank you!</p>