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?
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'