title: Union ALL fetches empty rows
body: <p>I have two query joined with a <code>union All</code>. </p>
  
  <pre><code>SELECT  select 'Finished' AS Status,amount AS amount,units As Date
  from table1 WHERE Pdate &gt; cdate AND name =@name
  UNION ALL
  SELECT  select 'Live' AS Live,amount,units 
  from table1  Where Pdate = cdate And name =@name
  </code></pre>
  
  <p>Result</p>
  
  <pre><code>Status     amount   units
  Finished     100    20
  Live         200    10
  </code></pre>
  
  <p>When either of the query fetches empty set I get only one row and, if both fetches empty set then I no rows</p>
  
  <p>So how can I get result like this</p>
  
  <pre><code>Status     amount   Units
  Finished     100    20
  Live         0      0
  </code></pre>
  
  <p>OR</p>
  
  <pre><code>Status     amount   Units
  Finished     0      0
  Live         200    10
  </code></pre>
  
  <p>OR</p>
  
  <pre><code>Status     amount   Units
  Finished      0          0
  Live          0          0
  </code></pre>
  
  <p>Thanks.</p>