Question

oracle从两个不同表中查询的结果 怎么合并

是这样的
有两张表
table1
table2

我要显示如下
table1的行数 table2的行数

我写了两个sql语句
select count(*) from table1;
select count(*) from table2;

我现在就想将两条sql语句变成一条sql语句

非常感谢

Answer 1

SELECT
(select count(*) from table1 ) AS COUNT_1 ,
(select count(*) from table2 ) AS COUNT_2
FROM DUAL

或者

SELECT X.COUNT_1,Y.COUNT_2
FROM
( select count(*) AS COUNT_1 from table1 ) X,
(select count(*) AS COUNT_2 from table2 ) Y

Answer 2

SELECT
(select count(*) from table1 )+
(select count(*) from table2 )
FROM DUAL