title: Outer Union equivalent - GBQ
body: <p>I've seen how an outer union would work in this post</p>
  <p><a href="https://stackoverflow.com/a/52524364/11883834">https://stackoverflow.com/a/52524364/11883834</a></p>
  <p>and I wanted to know how I would go about implementing something similar in Google Big Query, as when I try to run an outer union, I just get given back an error (I think because outer unions are not supported in GBQ).</p>
  <p>E.G.</p>
  <pre><code>Table1
  +---+---+
  | a | b |
  +---+---+
  | 1 | X |
  | 2 | Y |
  +---+---+
  
  Table2
  
  +---+---+
  | b | d |
  +---+---+
  | U | 1 |
  +---+---+
  
  CREATE TABLE OuterUnionTable AS
  SELECT * FROM Table1
  OUTER UNION CORR
  SELECT * FROM Table2
  
  OuterUnionTable
  +----+----+---+
  | a  | b  | d |
  +----+----+---+
  |  1 | X  |   |
  |  2 | Y  |   |
  |    | U  | 1 |
  +----+----+---+
  </code></pre>