title: MS ACCESS SQL issue with combine LEFT JOINS and INNER JOINS
body: <p>MS Access has been just killing me when It comes to writing my own SQL queries and I hate it's GUI query tool. I gave up trying to combine LEFT JOINS and INNER JOINS now I'm doing all inner join's and i'm still getting murdered. Can someone link to me to a comprehensible MS Access SQL guide and/ or tell me what I am doing wrong here. I've tried putting my code in parenthesis, bracketing my fields. I'm at my wits end.</p>
  
  <pre><code>SELECT answers.* 
  FROM (((answers
  INNER JOIN caseInfo 
      ON answers.[ABAWDNum] = caseinfo.[ABAWDNum])
  INNER JOIN Questions)
       ON answers.[questionID] = questions.[questionID]) 
  INNER JOIN responseCodes 
      ON answers.[responseIDCode] = responseCodes.[responsecode]
  </code></pre>
  
  <p>I'm not sure if my picture of the error is coming up but it says Sytnax error in FROM clause and it has the parenthesis right after the Questions table is mentioned
  <a href="https://i.stack.imgur.com/VH8rY.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p>EDIT: Database relationships:
  <a href="https://i.stack.imgur.com/lbHHU.png" rel="nofollow noreferrer">enter image description here</a></p>