title: Create View multiple tables and different column names
body: <p>I have 2 tables in my database:</p>
  
  <p><strong>DetectorStatus</strong></p>
  
  <pre><code>DetectorStatusID    DetectorID    DateTime    DetectorModeID    Status
        1                471          time            2            0.7
  </code></pre>
  
  <p><strong>StationStatus</strong></p>
  
  <pre><code>StationStatusID    DetectorID    DateTime    StationModeID    Status
        1                1541        time            2           0.74 
  </code></pre>
  
  <p>I want to create a view that looks like this:</p>
  
  <pre><code>StationStatusID    DetectorStatusID    DetectorID    DateTime    StationModeID    DetectorModeID    Status
        NULL                 1               471         time          NULL                2            0.7
        1                    NULL            1541        time          2                   NULL         0.74
  </code></pre>
  
  <p>Now, when i create the view like this: </p>
  
  <pre><code>CREATE view statusoverview AS
      SELECT * FROM [GMS_MAN].[dbo].[DetectorStatus]
      UNION ALL
      SELECT * FROM [GMS_MAN].[dbo].[StationStatus]
  </code></pre>
  
  <p>I get all the results inside 1 table. However <em>StationModeID</em> is inside <em>DetectorModeID</em> etc.</p>
  
  <p>How do i create a view that looks like the given example?</p>