Microsoft Query - FULL OUTER JOIN of 3 tables

[osianllwyd]

Hi,

I'd like to do a FULL OUTER JOIN of 3 tables in Excel.

Each table has 4 columns - 3 categories (for joining) and one metric column. All the 3 joining columns are the same across the 3 tables.

As MS Query does not support the FULL OUTER JOIN command it can only do this using UNION. There are numerous instructions on how to do this for 2 tables but I've not been able to find any help on how to do 3.

Can anyone help with a very basic syntax?

Thanks
Osian