title: Left join together with inner join in ms-access
body: <p>I have to run the following query in an access database:</p>
  
  <pre><code>    SELECT School.Name, Student.Name, Grade.Grade
      FROM( (`School` `School` LEFT JOIN `Student` `Student` ON `School`.`ID`=`Student`.`SchoolID`) INNER JOIN `Grade` `Grade` ON `Student`.`GradeID` = `Grade`.`ID`)
  </code></pre>
  
  <p>This gives me the error "Join expression not supported", but if I change the LEFT JOIN to INNER JOIN, it runs correctly. I think the way of using both these joins together on ms-access can have a different way. Can anyone pls tell me what is wrong in this query and/ or the reason that this is not supported.</p>
  
  <p>Thanks</p>