title: SQL Server : Union with multiple columns
body: <p>I want to union two querys with multiple columns like recommended in other posts like this</p>
  
  <pre><code>select NULL AS Col1
         ,NULL AS Col2
         ,NULL AS Col3
         ,Col4
         ,Col5
  
  union 
  
  select Col1
         ,Col2
         ,Col3
         ,NULL AS Col4
         ,NULL AS Col5
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>Col1 | Col2 | Col3 | Col4 | Col5 
  ---------------------------------
  NULL | NULL | NULL |  2   |  0
   7   |  3   |  4   | NULL | NULL
  </code></pre>
  
  
  
  <p>is there any way to combine the rows?
  Because of that alias I cant group by the columns.</p>
  
  <p>I want to get
  </p>
  
  <pre><code>Col1 | Col2 | Col3 | Col4 | Col5 
  ---------------------------------
    7  |  3   |   4  |  2   |  0
  </code></pre>