title: "join expression not supported" in Access
body: <p>I am writing a SQL query with inner join as this</p>
  
  <pre><code>select * from (table1 inner join table2 on table1.city = table2.code)
     inner join table3 on table3.col1 = 5 and table3.col2 = 'Hello'
  </code></pre>
  
  <p>This giving me the error "Join expression not supported".</p>
  
  <p>However, if I change the query like this then there is no error</p>
  
  <pre><code>select * from (table1 inner join table2 on table1.city = table2.code)
     inner join table3 on table3.col1 = [SomeColumn] and table3.col2 = [SomeColumn]
  </code></pre>
  
  <p>Why is Access giving me an error on the first query?</p>