禁用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屋!