禁用Access SQL查询中的括号 [英] disable parentheses in access sql queries

问题描述

是否有一种方法可以告诉ms access(2003)将 not 放入括号中.或至少在没有其他数据库的情况下了解它们

is there a way to tell ms access (2003) to not put joins into parentheses. or at least to understand them without (every other database does)

我想要类似的东西:

    SELECT *
      FROM a
INNER JOIN b
        ON a.a = b.a
INNER JOIN c
        ON b.c = c.c

但是访问权限告诉我该查询是错误的.并非如此，这让我发疯…

but access tells me that the query is wrong. IT’S NOT, and it’s driving me crazy …

它也将所有联接放在一行中–不可能读取

it also puts all joins in a single line—impossible to read

提前谢谢.

ps.我已经在设置中激活了ANSI 92兼容性/支持

ps. i already activated ANSI 92 compatibility/support in settings

推荐答案

不幸的是，没有. Access 2003只是关于SQL的愚蠢".这是错误的"，因为Access只能解析一个JOIN，这使您感到恼火(但仍然正确):

Sadly, no. Access 2003 is just that "dumb" about SQL. It is "wrong" in that Access can only parse one JOIN, which leaves you with the infuriating (but also still correct):

SELECT *
FROM a
INNER JOIN (b INNER JOIN c ON b.c = c.c)
    ON a.a = b.a

这篇关于禁用Access SQL查询中的括号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！