sql语句在查询分析器中可以运行，php的mssql_query却报错：

[石头子]

请大家帮忙看一下：
sql语句在查询分析器中可以运行，php的mssql_query却报错：

sql:

select distinct authorId from (SELECT top 100 b.name as authorName,b.id as authorId,b.ticket as ticket FROM table2 a left join table3 b on a.authorId=b.id where a.name='今天的作业' order by a.id desc)


错误信息：

[function.mssql-query]: message: 在关键字 ')' 附近有语法错误。 (severity 15)


sqlserver中可以运行的语句，php 中应该也可以吧？

[程序猿之殇]

select distinct c.authorId from (SELECT top 100 b.name as authorName,b.id as authorId,b.ticket as ticket FROM table2 AS a left join table3 AS b on a.authorId=b.id where a.name='今天的作业' order by a.id desc) AS C

尝试一下，没有环境

[石头子]

谢谢，楼上jakey9826,这样可以了

[石头子]

谢谢，楼上jakey9826,这样可以了