我的经验是使用SQL Server，但是你能做到:

select (select count(*) from table1) as count1,
  (select count(*) from table2) as count2

在SQL Server我得到的结果，你是后。

select @count = sum(data) from
(
select count(*)  as data from #tempregion
union 
select count(*)  as data from #tempmetro
union
select count(*)  as data from #tempcity
union
select count(*)  as data from #tempzips
) a

SELECT (SELECT COUNT(*) FROM table1) + (SELECT COUNT(*) FROM table2) FROM dual;

作为附加信息，要在SQL Server中完成同样的事情，您只需要删除查询的“FROM dual”部分。

select (select count(*) from tab1) count_1, (select count(*) from tab2) count_2 from dual;

选择 (select count() from tab1 where field like 'value') + (select count() from tab2 where field like 'value') 数