怎么union计算查找总数

[y_cc]

比如说
(select count(*) from mo_200509) union (select count(*) from mo_200510)

我想要知道他们联合后的总结果数，不是分开来的

[y_cc]

没有人能帮我一下吗，

[vcmute]

=>DB

[Mr_Yang]

这个不就是取并集吗！

[hahu]

select count(*) as acount from mo_200509
union
select count(*) as acount from mo_200510

如果两个表的字段名相同可以(*用相同的字段替换也可)
(select * from mo_200509 union select * from mo_200510)
select count(*) from mo_200509) union (select count(*) from mo_200510