select count(*) from table1 + count(*) from table2
select sum(count(*) from table1,count(*) from table2)
select (select count(PrimaryKeyID) from FirstTable) + (select COUNT(PrimaryKeyID) from TableSecond)
select (select count(*) from FirstTable) + (select COUNT(*) from TableSecond)