晕死,一个SQL语句在ASP下就是不能执行,谁能帮我解决?!!!
select distinct spbh from dqkc where bmmc='总库房' and spbh not in (select distinct spbh from spdb where dcbm='总库房' and shr is not null and fhrq between '200210250000' and '200211092359') and spbh not in (select distinct spbh from spys where shr is not null and ysrq between '200210250000' and '200211092359')
<查找在后两个SELECT结果集中均不存在的结果集>
就是这个语句,在SYBASE数据库上可以执行,可是写在ASP里就出错,晕死,谁能帮我解决?救救我吧!!!!!!!!!