title: How to combine two query's results into one row?
body: <p>I have two queries that return one result each i.e one number</p>
  
  <pre><code>Select Count(*) as StockCountA from Table_A where dept='AAA'
  </code></pre>
  
  <p>Results</p>
  
  <pre><code>StockCountA 
  550
  </code></pre>
  
  <p>.</p>
  
  <pre><code>Select Count(*) as StockCountB from Table_B where dept='BBB'
  </code></pre>
  
  <p>Results</p>
  
  <pre><code>StockCountB 
  450
  </code></pre>
  
  <p>I wish to join the two results into one row record i.e</p>
  
  <pre><code>| StockCountA | StockCountB    
  | 550         | 450
  </code></pre>