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

[anthgav]

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

SELECT tblWarehouse.warehouse,
		tblArea.area,
		tblBay.bay,
		tblBay.bay_width_mm,
		tblBay.bay_height_mm,
		tblBay.bay_depth_mm,
		tblBinType.priority,
		tblBinType.bin_type,
		tblBin.bin,
		tblBin.bin_width_mm,
		tblProduct.product,
		tblProduct.dimension,
		tblProduct.comment
FROM `Z:\Planner\Planner.accdb`.tblAllocatedBin tblAllocatedBin,
		`Z:\Planner\Planner.accdb`.tblArea tblArea,
		`Z:\Planner\Planner.accdb`.tblBay tblBay,
		`Z:\Planner\Planner.accdb`.tblBin tblBin,
		`Z:\Planner\Planner.accdb`.tblBinType tblBinType,
		`Z:\Planner\Planner.accdb`.tblProduct tblProduct,
		`Z:\Planner\Planner.accdb`.tblProductData tblProductData,
		`Z:\Planner\Planner.accdb`.tblWarehouse tblWarehouse
WHERE tblWarehouse.warehouse_id = tblArea.warehouse
		AND tblArea.area_id = tblBay.area
		AND tblBay.bay_id = tblBin.bay
		AND tblBin.bin_id = tblAllocatedBin.allocated_bin
		AND tblBinType.bin_type_id = tblAllocatedBin.allocated_bin_type
		AND tblAllocatedBin.allocated_bin_id = tblProduct.allocated_bin
		AND tblProductData.PTZ_product = tblProduct.product
ORDER BY tblWarehouse.warehouse, tblArea.area, tblBay.bay, tblBin.bin, tblBinType.priority

How can I achieve what I want?

[Kyle123]

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