FULL OUTER JOIN

The both tables will include all their records.

Matched records will be stored in the same record.

If no match is found on a table then all the columns related to the other table will be null.

SELECT *
FROM SchemaName.LeftTable AS LeftTable  
	FULL OUTER JOIN  SchemaName.RightTable AS RightTable
	ON LeftTable.colName = RightTable.colName