多表统计，如何得出统计结果的和

[sunshine320]

我要统计两个表，计算两个表数据的和，SQL如下所示

select count(*) num from logreadtable
union all
select count(*) num from logprinttable

结果如下：
num
2
11

如何得出这两个查询结果的和，就是2+11=13？

[luoyoumou]

select count(1) from (
select 1 as cnt from logreadtable
union all
select 1 as cnt from logprinttable
) t;

[zhizhuo89]

select sum(num) from (
select count(*) num from logreadtable
union all
select count(*) num from logprinttable
);

[emon123]

同意楼上的！

[wqmgxj]

select count(*) num from logreadtable,logprinttable
也可以

[sunshine320]

[Quote=引用 2 楼 zhizhuo89 的回复:]
select sum(num) from (
select count(*) num from logreadtable
union all
select count(*) num from logprinttable
);
[/Quote]
这个是正解