title: How to union multiple table in MYSQL
body: <p>How can I union multiple table in mysql and order by date?</p>
  
  <p>I have 3 differents tables and I want to make a query to get all data inside that and order by date</p>
  
  <pre><code>SELECT * FROM table1, table2, table3 ORDER by date DESC
  
  
  TABLE 1 
  
  ID  |  USER ID | DATE | 
   2      4        2018
  
  TABLE 2 
  
  ID  |  CAR ID | DATE | 
   3       9      2017
  
  TABLE 3
  
  ID  |  AIR ID | DATE | 
   4      6        2019
  </code></pre>
  
  <p>I expected result like this</p>
  
  <pre><code>ID | ALLID | DATE
  2      4      2018
  3      9      2017
  4      6      2019
  </code></pre>