title: sql access inner join of 4 tables
body: <p>I am new to sql and I am trying to join 4 tables together but just cant get the hang of it.
  I am trying to do this with an inner join but I always get an syntax error with access.</p>
  
  <pre><code>SELECT * 
  from kdst,aufpos 
  inner join( artst inner join vert on kdst.vertreter = vert.vertnr)
  on aufpos.artnr = artst.artnr;
  </code></pre>
  
  <p>This is my code but it does not work. I dont know what to do anymore, I hope someone can help me.</p>