title: ms access - 3 table join w/ complex JOIN condition on third table
body: <p>I need to join multiple tables in access. 
  Access has some odd syntax when it comes to joins, and I cant seem to get this right </p>
  
  <p>In particular, C needs to consider fields from both A and B</p>
  
  <pre><code> select a.*, B.*, c.* 
    from 
    (tblOne as A 
     Left join tblTwo as B on  A.ParentId = B.Id )
     left join tblThree as C on C.ParentId = B.Id and C.ShoeSize = A.ShoeSize
  </code></pre>
  
  <p>I have encountered and gotten past putting each Parens thing when more than 2 tables are involved. 
  I can join in C as long as I only want to refer to 1 of the other tables. 
  This type thing is fairly straight forward in SQL Server. 
  Any help would be appreciated, I cant seem to find an answer on google. </p>
  
  <p>The client is currently using ms Access 2003. If the problem can be remedied by a newer version, I am pretty I could talk them into an upgrade. </p>
  
  <p>thanks </p>
  
  <p>greg </p>