2种基本查询 ，得到结果少10条数据

引用

SELECT count(*) FROM [sxjjlb_dq] a,ryxxb b
where rjsj between '2013-11-01 00:00:00.000' and '2013-11-30 23:59:59.000'
and a.zjhm=b.zjhm
order by a.zjhm

引用

SELECT count(*) FROM [sxjjlb_dq]
where rjsj between '2013-11-01 00:00:00.000' and '2013-11-30 23:59:59.000'

[解决办法]
这样？SELECT count(*) FROM [sxjjlb_dq] a,ryxxb b
where rjsj between '2013-11-01 00:00:00.000' and '2013-11-30 23:59:59.000'
and a.zjhm=b.zjhm
order by a.zjhm
having count(*)<10


SELECT count(*) FROM [sxjjlb_dq]
where rjsj between '2013-11-01 00:00:00.000' and '2013-11-30 23:59:59.000'
having count(*)<10