This sql is working in Access, but not in my Zoho Reports environment that is a mirror image.

 

SELECT Questions.Q_ID, Questions.Question, Schools.Fullname, Answers.Survey_Year, Answers.Response
FROM Schools INNER JOIN (Questions INNER JOIN Answers ON Questions.Q_ID = Answers.Q_ID) ON Schools.School_ID = Answers.School_ID

 

Any suggestions?