我有一句ASP查询字段数量总和的语句查不到值,帮看看

代码是:<%set quality=conn.execute("select isnull(sum(quality),0) as quality from dingdan where prodid in (select * from production where ProdTJ=1 or ProdTJ2=1 or ProdTJ3=1 and ProdId='"&Q_spid&"') and datediff('h',date(),addtime)< 24 ")
 %>

Quality查不到值,帮看看

查不到值的原因很多，如果查询语句没有报错的话，应该是条件有问题，这个只能你自己不断改变条件的值来慢慢测试。

select isnull(sum(quality),0) as quality from dingdan where prodid in (select * from production where ProdTJ=1 or ProdTJ2=1 or ProdTJ3=1 and ProdId='"&Q_spid&"') and datediff('h',date(),addtime)< 24 
不应该用*吧