Multiple left joins in Microsoft Query from an Access database to pivot table

Hi

I have an Access database and I'm pulling data into a pivot table using Microsoft Query.
The data successfully pulls through OK but I'm missing values that don't link to other tables.
Ideally I want to use multiple LEFT JOINs to display all values in table1 and anything that matches in table2, then anything in table3 that matches table2 and so on....
Microsoft Query does not allow for LEFT JOIN when there are multiple tables.

Here is an image of my tables and their relationships in Microsoft Query...
Query.PNG

Here is the SQL from Microsoft Query

Please Login or Register  to view this content.

How can I achieve what I want?

Can't you just switch to sql mode and write it?