KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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?
Tags (comma-separated)
Save Edits
Cancel