title: How to get AS two separate selectors with UNION?
body: <p>As sadly SQL is my weakest skill.</p>
  
  <p>I'm trying to use <code>UNION</code> in a <code>VIEW</code>, where I can get statistics from two different tables with one query.</p>
  
  <pre><code>SELECT COUNT(*) AS `customer_count` FROM `Customers`
  UNION
  SELECT COUNT(*) AS `supplier_count` FROM `Suppliers`;
  </code></pre>
  
  <p><sup><strong>[<a href="http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_union" rel="nofollow">Demo table</a>]</strong></sup></p>
  
  <p>However, it only returns <strong>customer_count</strong>, with two rows. Is there anyway, to make this work, so it returns <strong>customer_count</strong> and <strong>supplier_count</strong> separately?</p>