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

huoyu5

还是错的，“当没有用exists引入子查询时，在选择列表中只能指定一个表达式”，

huoyu5

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 1 i.id from info as i where  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"
改成这样好象可以了