title: Select all columns from two tables
body: <p>Lets say I have the following:</p>
  
  <p><strong>table_a</strong></p>
  
  <pre><code>| id |    date    | order_id | sku | price |
  --------------------------------------------
  | 10 | 2016-08-18 |    111   | ABC |   10  |
  </code></pre>
  
  <p><strong>table_b</strong></p>
  
  <pre><code>| id |    date    | order_id | description | type | notes | valid |
  -------------------------------------------------------------------
  | 50 | 2016-08-18 |    111   |     test    |  AA  |       | true  |
  </code></pre>
  
  <p>I want to get get all columns from both tables, so the resulting table looks like this:</p>
  
  <pre><code>| id |    date    | order_id | sku | price | description | type | notes | valid |
  ---------------------------------------------------------------------------------
  | 10 | 2016-08-18 |    111   | ABC |   10  |             |      |       |       |
  ---------------------------------------------------------------------------------
  | 50 | 2016-08-18 |    111   |     |       |     test    |  AA  |       | true  |
  </code></pre>
  
  <p>I tried union:</p>
  
  <pre><code>(
   SELECT *
   from table_a
   where table_a.date &gt; Date('today')
  )
  UNION 
  (
   SELECT *
   from table_b
   where table_b.date &gt; Date('today')
  )
  </code></pre>
  
  <p>But I get a:</p>
  
  <pre><code>ERROR: each UNION query must have the same number of columns
  </code></pre>
  
  <p>How can this be fixed / is there another way to do this?</p>