title: MS Access SQL using multiple left joins
body: <p>The below join works in Access, but I need to add a fourth join. </p>
  
  <pre><code>FROM ((Agents
  LEFT JOIN Resignation_Pool    ON Agents.PF = Resignation_Pool.PF)
  LEFT JOIN Teams               ON Agents.Team = Teams.ID)
  LEFT JOIN Skills              ON Agents.PF = Skills.PF
  </code></pre>
  
  <p>When I add the fourth join, it doesn't work.  I know Access is weird about the parenthesis, but I think I have them where they belong.  The query just runs forever doing nothing (it shouldn't run long at all) and I end up cancelling it.  Any suggestions?</p>
  
  <pre><code>FROM (((Agents
  LEFT JOIN Resignation_Pool    ON Agents.PF = Resignation_Pool.PF)
  LEFT JOIN Teams               ON Agents.Team = Teams.ID)
  LEFT JOIN Skills              ON Agents.PF = Skills.PF)
  LEFT JOIN OneMore             ON Agents.OM = OneMore.OM
  </code></pre>
  
  <p>Here is the code that works - my actual query instead of one I found that looked similar. </p>
  
  <pre><code>SELECT DISTINCT A02.PID, A02.PS, A02.PN, A02.PM, C01.RC, C01.IC, C01.RD 
  INTO AutoCR 
  FROM ((02_CorrectResults A02 
  LEFT OUTER JOIN dbo_pol_PGI C01 
    ON (A02.PID = C01.PID and C01.PS = '999' and C01.PEDate &gt;= #04/01/2012#)) 
  LEFT OUTER JOIN dbo_pol_IL C02 
    ON C01.PID = C02.PID) 
  LEFT OUTER JOIN dbo_pol_UN C03 
    ON C02.ILID = C03.ILID
  </code></pre>
  
  <p>I add another join and this doesn't work. I tried using inner join instead but Access doesn't like that. </p>
  
  <pre><code>SELECT DISTINCT A02.PID
  , A02.PS
  , A02.PN
  , A02.PM
  , C01.RC
  , C01.IC
  , C01.RD
  , C04.CCode
  , C04.PCode
  , C04.CForm,
  INTO AutoCR 
  FROM (((02_CorrectResults A02 
  LEFT OUTER JOIN dbo_rol_PGI C01 
    ON (A02.PID = C01.PID and C01.PS = '999' and C01.PEDate &gt;= #04/01/2012#)) 
  LEFT OUTER JOIN dbo_rol_IL C02 
    ON C01.PID = C02.PID) 
  LEFT OUTER JOIN dbo_rol_UN C03 
    ON C02.ILID = C03.ILID) 
  LEFT OUTER JOIN dbo_rol_HO C04 
    ON C03.UnID = C04.UnID
  </code></pre>