title: Nested inner join & sub-select in Access
body: <p>I have this SQL in Access, but it is giving me an error. I've tried moving the parenthesis around but it hasn't resolved the issue.</p>
  
  <pre><code>SELECT
      a.title, a.id, a.name, l.user, l.time 
  FROM
      Reports a
  INNER JOIN (
      AuditLog AS l ON a.id = l.id
  INNER JOIN (
  (
      SELECT min(time) Mintime, id
      from AuditLog
      GROUP BY id
  ) AS t )
    ON l.id = t.id
    AND l.time = t.mintime )
  WHERE
      a.NAME LIKE 'something*'
      AND a.ACTIVE='Y'
  </code></pre>
  
  <p>How can I resolve the syntax errors I'm getting?</p>