title: amazon athena - select from multiples tables without join
body: <p>I have three tables. Each table has common columns with the two other tables, with difference in some attributes. As I am interested in the common attribute, I would like to make one single request to get data from all three tables.</p>
  
  <p>I need to get the items from all three tables by UNION. Is it possible in AWS Athena?</p>
  
  <p>ex:</p>
  
  <pre><code>table1 (att1, att2, att3)
  table2 (att1, att2, att_3)
  table3 (att1, att2, att3, att4)
  </code></pre>
  
  <p>Goal: get items from table1, table2, table3 without join in the same request.</p>