SQL Left Join multiple tables

Question

I have 5 relational tables, let's say a,b,c,d,e.

How can I left join 4 of the tables "b,c,d,e" onto table "a" using a unique column "ID" which is present in all the tables?

I want to do this in MS Access using sql query.

Answer 1

In MS Access, you need a bunch of parentheses:

select . . .
from (((a left join
        b
        on a.id = b.id
       ) left join
       c
       on a.id = c.id
      ) left join
      d
      on a.id = d.id
     )
     on a.id = e.id;