SQL Server FULL OUTER JOIN

SQL Server FULL OUTER JOIN

               SQL Server FULL OUTER JOIN joins tables on matching condition and non-matching rows from parent table with null values from child table.i.e both side data will be displayed.

All data from parent table on matched condition and non-macthed rows from parent table with null value in child table.

for ex:  Employee should belong to Department.

Here Department is Parent Table and Employee is Child Table.

Whenever u perform FULL OUTER JOIN, all rows from parent table(DEPT) will be displayed