title: ms access query error
body: <p>I'm converting my database from SQL Server to MS Access.</p>
  
  <p>This query works fine in SQL Server, but it has syntax error in MS-Access.</p>
  
  <p>So what is wrong with this SQL statement??</p>
  
  <pre><code>select * 
  from Students 
  left join (select Lessons.StudentID, COUNT(*) as LessonsCount 
             from Lessons 
             group by Lessons.StudentID) as c on c.StudentID = Students.ID  
  left join (select Tests.StudentID, count(*) as TestsCount 
             from Tests 
             group by Tests.StudentID) as dd on dd.StudentID = c.StudentID
  </code></pre>