title: Merge one table field that is email in three tables
body: <p>I want a query to get the result of merging one field, email in three different tables from the same database, how do I do that?</p>
  
  <p>Below is my code</p>
  
  <pre><code>SELECT * FROM luckydraw_weekone 
  LEFT JOIN luckydraw_weektwo ON luckydraw_weekone.id = luckydraw_weektwo.id 
  LEFT JOIN participants ON luckydraw_weekone.id = participants.id;
  </code></pre>
  
  <p>Thanks </p>