I do n’t know what's wrong, there is a syntax error near i

huoyu5

It's still wrong, "When no subqueries are introduced with exists, only one expression can be specified in the select list",

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"
Change it to like this