ms-accessms-access-2007

"join expression not supported" in Access


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]

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


Solution

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

    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'