MapGeek,

Try this and tell me is it solving your problem or not

select sum( counter)
from (select count(*) counter from Table1
Union
select count(*) from Table2
);

Sheetal