Table of contents

ORDER BY 子句与互异的冲突。(错误 3093)ORDER BY clause conflicts with DISTINCT. (Error 3093)

office 365 dev account|上次更新日期: 2018/3/13
2 参与人员

适用于:访问 2013年 |访问 2016 年Applies to: Access 2013 | Access 2016

您创建了一个 SQL 语句,其中含有 ALL、DISTINCT 或 DISTINCTROW 谓词以及 ORDER BY 子句,而该子句中包含 SELECT 语句中未列出的字段。请移除 DISTINCT 保留字,或者从 ORDER BY 子句中移除指定字段。You created an SQL statement with an ALL, DISTINCT, or DISTINCTROW predicate and an ORDER BY clause that contains a field not listed in the SELECT statement. Remove the DISTINCT reserved word, or remove the specified field from the ORDER BY clause.

访问 MSDN 上的开发人员论坛Access for developers forum on MSDN 的访问帮助Access help on 的访问帮助Access help on
特定的访问权限错误代码,在 Bing 上搜索Search for specific Access error codes on Bing
访问论坛 UtterAccess 上Access forums on UtterAccess
访问 wiki 上 UtterAcessAccess wiki on UtterAcess
访问开发人员和 VBA 编程帮助中心 (FMS)Access developer and VBA programming help center (FMS)
在 StackOverflow 上访问张贴内容Access posts on StackOverflow

© 2018 Microsoft