需求为统计5张表数据量,但是经计算统计的总数偏少,主要sql代码如下
select
count(name)as num
from
"a"
union
select
count(smid)as num
from
"b"
union
select
count(smid)as num
from
"c"
union
select
count(name)as num
from
"d"
union
select
count(mc)as num
from
"e"
结果如下::
结果只产生了四条数据,测试只用前四张表统计。 还是只是四条数据,