title: SQL: Combine Select count(*) from multiple tables
body: <p>How do you combine multiple select count(*) from different table into one return?</p>
  
  <p>I have a similar sitiuation as this <a href="https://stackoverflow.com/questions/606234/select-count-from-multiple-tables">post</a></p>
  
  <p>but I want one return.</p>
  
  <p>I tried Union all but it spit back 3 separate rows of count. How do you combine them into one?</p>
  
  <pre><code>select count(*) from foo1 where ID = '00123244552000258'
  union all 
  select count(*) from foo2 where ID = '00123244552000258'
  union all
  select count(*) from foo3 where ID = '00123244552000258'
  </code></pre>
  
  <p>edit: I'm on MS SQL 2005</p>