在SQLSERVER中正常但是在ASP中不正常
SQL语句是：select sum(rzbf) rzbf,sum(ysbf) ysbf,sum(ssbf) ssbf from (select sum(hjbf) rzbf,sum(hjysbf) ysbf,sum(hjssbf) ssbf from h_cbtz where 1=1 and jbr in ( '005011 ') group by polno having sum(hjysbf)!=0 and max(jfrq) between '9/11/2006 ' and '10/11/2006 ')
在SQLSERVER中尝试运行没有任何问题，但是在ASP中运行后却报
Microsoft OLE DB Provider for SQL Server 错误 '80040e14 '
Line 1: Incorrect syntax near ') '.
/tj/yshou/yshou.asp，行 154
错误，请大家帮忙看看，ASP语句没有问题，我把SQL换成
select sum(hjbf) rzbf,sum(hjysbf) ysbf,sum(hjssbf) ssbf from h_cbtz where 1=1 and jbr in ( '005011 ') group by polno having sum(hjysbf)!=0 and max(jfrq) between '9/11/2006 ' and '10/11/2006 '
就很正常（当然这个结果不是我想要的结果，我想要的效果是上条SQL的执行结果），真奇怪，请大家帮忙，谢谢。
[解决办法]
你这两个sql并不是同一样.错误的原因是子查询没有指定别名.try:select sum(AA.rzbf) rzbf,sum(AA.ysbf) ysbf,sum(AA.ssbf) ssbf from (select sum(hjbf) rzbf,sum(hjysbf) ysbf,sum(hjssbf) ssbf from h_cbtz where 1=1 and jbr in ( '005011 ') group by polno having sum(hjysbf)!=0 and max(jfrq) between '9/11/2006 ' and '10/11/2006 ')AS AA
