“不支持连接表达式"在访问中 [英] "join expression not supported" in Access

问题描述

我正在编写一个带有内部连接的 SQL 查询

I am writing a SQL query with inner join as this

select * from (table1 inner join table2 on table1.city = table2.code)
   inner join table3 on table3.col1 = 5 and table3.col2 = 'Hello'

这给了我错误不支持加入表达式".

This giving me the error "Join expression not supported".

但是，如果我像这样更改查询，则没有错误

However, if I change the query like this then there is no error

select * from (table1 inner join table2 on table1.city = table2.code)
   inner join table3 on table3.col1 = [SomeColumn] and table3.col2 = [SomeColumn]

为什么 Access 在第一次查询时给我一个错误?

Why is Access giving me an error on the first query?

推荐答案

为什么 Access 在第一次查询时给我一个错误?

Why is Access giving me an error on the first query?

好吧，就像错误消息所说的那样，不支持这种形式的 JOIN 表达式.

Well, like the error message says, that form of a JOIN expression is not supported.

您可能想尝试以下操作:

You might want to try the following:

SELECT * FROM table1, table2, table3 
WHERE table1.city=table2.code AND table3.col1=5 AND table3.col2='Hello'

这篇关于“不支持连接表达式"在访问中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！