title: How do I join 4+ tables in Access with a combination inner/outer?
body: <p>I have not been able to find a way to join 4 or more tables using outer join in MSAccess. It works in SQL Server, but not Access. I don't believe it is possible. I have tables A, B, C, D and E. I need to join the tables like so:</p>
  
  <ul>
  <li>A left outer join B</li>
  <li>A left outer join C</li>
  <li>A inner join D</li>
  <li>B inner join E</li>
  </ul>
  
  <p>Access won't let you use conventional joins in the where clause when you use LEFT/RIGHT/INNER JOINS in the FROM clause. If you do, I get very, very vague errors like "JOIN expression not supported" or "Syntax error (missing operator) in query expression". I may be able to use a pass-through query, but I don't know how to do that yet. The most tables I can join are 3 with outer joins like this:</p>
  
  <p>FROM (A left join B on A.b = B.b)<br>
  left join C on A.c = C.c</p>
  
  <p>Don't say anything about 'outer' keyword not allowed either, because though it is not in the documentation, it does accept it.</p>