title: Select count(*) from multiple tables
body: <p>How can I select <code>count(*)</code> from two different tables (call them <code>tab1</code> and <code>tab2</code>) having as result:</p>
  
  <pre><code>Count_1   Count_2
  123       456
  </code></pre>
  
  <p>I've tried this:</p>
  
  <pre><code>select count(*) Count_1 from schema.tab1 union all select count(*) Count_2 from schema.tab2
  </code></pre>
  
  <p>But all I have is:</p>
  
  <pre><code>Count_1
  123
  456
  </code></pre>