>>
>>select sum(cntTotal) as Total
>>FROM
>>(select count(..) as cntTotal from myFirstTable ...
>>UNION ALL
>>select count(..) as cntTotal from mySecondTable) X
>
>Thanks
>
>That's what I used but did not include the ALL.
UNION without ALL will do a distinct select. For your case most likely you need UNION ALL.
If it's not broken, fix it until it is.
My Blog