“不支持连接表达式"在访问中

问题描述

我正在编写一个带有内部连接的 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?

推荐答案

好吧，就像错误消息所说的那样，不支持这种形式的 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'

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