Full Outer Join in MS Access - Office 365

The Full Outer Join returns records that includes rows from both left and right tables. When no matching rows exist for the row in the left table, the columns of the right table will have nulls. Similarly, when no matching rows exist for the row in the right table the columns of the left table will have nulls. MS Access does not explicitly support full outer joins but you can achieve the same effect by using a union query.

[jsx]

How can you do this with more than 1 column?

[josefinamartina]

THANK YOU, YOUR VIDEO WAS VERY USEFUL.