>This page lists some variations on how to accomplish this:
>
>http://stackoverflow.com/questions/1279569/sql-combine-select-count-from-multiple-tables
>
>However, any additional input would be welcome.

select sum(cntTotal) as Total
FROM
(select count(..) as cntTotal from myFirstTable ...
UNION ALL
select count(..) as cntTotal from  mySecondTable) X