不知道错那了，i附近有语法错误

huoyu5

读取第2-10条记录，i附近有语法错误，请高手救命啊？
Set Dets=Conn.Execute("select top 10  i.bid,i.id,i.title,i.pic,i.path, b.name,b.orderid from info as i,infobigsort as b where i.id not in(select top 10 i.id,b.orderid from info as i,infobidsoft as b where i.bid=b.orderid and i.Commend_index=1 and agree=1 order by i.addtime desc) i.bid=b.orderid and i.Commend_index=1 and agree=1 order by i.addtime desc")

dydcool

你先测试一下你的SQL语句是否成功。

huoyu5

怎么测试啊，没用过，'i' 附近有语法错误。

kiddivl

晕湖..........学习ING  

I  从哪来的 啊  ,好象跟那个没声明却先引用 有点相似哦

huoyu5

info as i，就这里啊，
Set Dets=Conn.Execute("select top 10  i.bid,i.id,i.title,i.pic,i.path, b.name,b.orderid from info as i,infobigsort as b where i.bid=b.orderid and i.Commend_index=1 and agree=1 order by i.addtime desc")
单独这样就正确的

windmimi

i.bid=b.orderid and i.Commend_index=1 and agree=1 order by i.addtime desc最后这条是哪条的查询啊，这里应该就两个查询吧。

windmimi

去掉这条试试看：i.bid=b.orderid and i.Commend_index=1 and agree=1 order by i.addtime desc")

huoyu5

是去那个括号理的

windmimi

最后一个

hellobn

你的WHERE条件错了，改成这样子吧：
Set Dets=Conn.Execute("select top 10  i.bid,i.id,i.title,i.pic,i.path, b.name,b.orderid from info as i,infobigsort as b where i.id not in(select top 10 i.id,b.orderid from info as i,infobidsoft as b where i.bid=b.orderid and i.Commend_index=1 and agree=1 order by i.addtime desc) AND i.bid=b.orderid and i.Commend_index=1 and agree=1 order by i.addtime desc")