When using a full outer join between two tables having some common columns and some unique columns,columns from the first table that do not have corresponding columns in the second table would contain null values and columns from the second table that do not have corresponding columns in the first table would contain null values.

Question

Quizplus · Accepted Answer

This is true for a full outer join. The common columns would have values populated according to their respective matching rows, while the unique columns from each table would have null values for the rows where there is no match in the other table.

When Using a Full Outer Join Between Two Tables Having