How to join 4+ tables in Access with a combination of internal / external?

Question

I was unable to find a way to join 4 or more tables using an external join in MSAccess. It works in SQL Server, but not in Access. I do not believe that this is possible. I have tables A, B, C, D, and E. I need to join the tables like this:

• Left outer join B
• Left outer join C
• Internal connection D
• B inner connection E

Access will not allow you to use regular joins in the where clause when you use LEFT / RIGHT / INNER JOINS in the FROM clause. If you do this, I get very, very vague errors, such as the JOIN expression is not supported, or "Syntax error (missing statement) in the query expression." I can use a pass-through query, but I don’t know yet how to do it. Most tables I can join are 3 with outer joins:

FROM (left connection B on Ab = Bb)
left connection C on Ac = Cc

Nothing was said about the keyword 'outer', because although it is not in the documentation, it accepts it.

Answer 1

. , , , .

Answer 2

Access . , :

from
   (
      (
         (
            A inner join D on D.id = A.id
         )
         left join B on B.id = A.id
      )
      inner join E on E.id = B.id
   )
   left join C on C.id = A.id