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