请帮忙看看多表查询结果分页处理的SQL语句的错误怎样修改?
有一个小项目,用到了多表查询结果分页处理,我用的SQL语句是:
SELECT TOP @pagesize PE_Article.ArticleID, PE_Article.ChannelID, PE_Article.ClassID, PE_Article.Title, PE_Class.ClassName,PE_Channel.ChannelDir FROM PE_Article INNER JOIN PE_Class ON (PE_Class.ClassID=PE_Article.ClassID) INNER JOIN PE_Channel ON (PE_Channel.ChannelID=PE_Article.ChannelID) AND PE_Article.ClassID=301 WHERE PE_Article.ArticleID NOT IN (SELECT TOP @startrow PE_Article.ArticleID, PE_Article.ChannelID, PE_Article.ClassID, PE_Article.Title, PE_Class.ClassName,PE_Channel.ChannelDir FROM PE_Article INNER JOIN PE_Class ON (PE_Class.ClassID=PE_Article.ClassID) INNER JOIN PE_Channel ON (PE_Channel.ChannelID=PE_Article.ChannelID) AND PE_Article.ClassID=301 ORDER BY PE_Article.ArticleID DESC) ORDER BY PE_Article.ArticleID DESC
查询分析器提示错误:
消息 116,级别 16,状态 1,第 1 行
当没有用 EXISTS 引入子查询时,在选择列表中只能指定一个表达式。
请问应该怎样修改才能正确通过?