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

问题描述

我正在编写具有内部联接的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'

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