title: SQL UNION two tables with different column names
body: <p>How do I union two tables where their are columns that have different names in the two tables. Table1 has the column name 'Measure'; the data that matches this in Table2 has the column name 'Metric'.</p>
  
  <p>I have tried the following but it returns zero results when I run the query:</p>
  
  <pre><code>CREATE VIEW `Dataset.Combined_Table` AS (                                
  SELECT
  Date, Account, Measure
  
  FROM
  `Dataset.Table1` 
  
  UNION ALL
  
  SELECT Date, Account, Metric Measure
  
  FROM `Dataset.Table2` )
  </code></pre>