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