title: Merge two SQL query results into one result
body: <p>I have query like below:</p>
  
  <pre><code>SELECT COUNT(*) AS AppleSupports 
  FROM VendorItemPricing 
  WHERE VendorName = 'Apple'
  
  SELECT COUNT(*) AS HpSupports 
  FROM VendorItemPricing 
  WHERE VendorName = 'HP'
  </code></pre>
  
  <p>Above queries give me results like below:</p>
  
  <pre><code>AppleSupports
  63
  
  HpSupports
  387
  </code></pre>
  
  <p>How can make my query to get results in one row like below?</p>
  
  <pre><code>AppleSupports    HpSupports
  63               387
  </code></pre>