title: Syntax error (missing operator) in query expression
body: <p>I have the following SQL Statement that works fine in SQL Server but in Access gets me an error</p>
  
  <pre><code>'ERM_HAZARD.[HAZARDID] = ERM_XREF_HAZARD_CAT.[HAZARDID] 
  INNER JOIN ERM_HAZARDSTATUS 
  ON ERM_HAZARD.HAZARDSTATUSID = ERM_HAZARDSTATUS.HAZARDSTATUSI'
  </code></pre>
  
  <hr>
  
  <pre><code> SELECT erm_hazard.hazardid    AS PKTrans,
         erm_hazard.extref      AS No,
         erm_cat.name           AS CaseType,
         erm_hazard.created     AS CaseDate,
         erm_hazard.name        AS Title,
         erm_hazard.description AS DescriptionTrans,
         erm_organisation.name  AS ResponsibleUnit,
         erm_hazard.reviewdate  AS CaseDeadline,
         erm_hazardstatus.name  AS Status,
         erm_organisation.name  AS UnitInCharge,
         erm_personel.name      AS PersonInCharge
  FROM   (erm_personel
          INNER JOIN (erm_organisation
                      INNER JOIN erm_hazard
                              ON erm_organisation.[organisationid] =
                                 erm_hazard.[organisationid])
                  ON erm_personel.[personelid] = erm_hazard.[personelid])
         INNER JOIN (erm_cat
                     INNER JOIN erm_xref_hazard_cat
                             ON erm_cat.[catid] = erm_xref_hazard_cat.[catid])
                 ON erm_hazard.[hazardid] = erm_xref_hazard_cat.[hazardid]
         INNER JOIN erm_hazardstatus
                 ON erm_hazard.hazardstatusid = erm_hazardstatus.hazardstatusid
  WHERE  (( ( erm_xref_hazard_cat.periodid ) = (SELECT Max(
                                               erm_xref_hazard_cat.periodid)
                                                FROM   erm_xref_hazard_cat) ))
  ORDER  BY erm_xref_hazard_cat.periodid DESC,
            erm_hazard.hazardid,
            erm_cat.name  
  </code></pre>
  
  <p>Is this a Access SQL Size problem? 
  Any ideas? </p>