简单的sql语句！想把记录合在一起！

[showmetoyou]

有两个表month，cmonth，都有一定的数据！现想得到他们的记录条数！
结果如下：
new old
66843 153249
我的语句是通过变量得到的如下（速度挺快的）：
declare @monthcount varchar(20)
declare @cmonthcount varchar(20)

select @monthcount= count(distinct userid) from dbo.month
select @cmonthcount= count(distinct userid) from dbo.cmonth

select @monthcount as new ,@cmonthcount old
现在我希望是一条sql语句！请大家帮忙！
我使用下面的语句：
select count(distinct a.userid),count(distinct b.userid) from dbo.month as a ,dbo.cmonth b
执行半天就是不出来结果，请问哪里错了！

[zjcxc]

select (select count(distinct userid) from dbo.month) as new
,(select count(distinct userid) from dbo.cmonth) as old

[xluzhong]

select type,count(*)
from(
select distinct(userid),'new' as type from month
union all
select distinct(userid),'old' as type from cmonth)t
group by type

[showmetoyou]

哈哈！大哥出手果然不同反响！谢谢啦！结贴！