FULL & SELF JOIN

FULL JOIN

The SQL FULL JOIN combines the results of both left and right outer joins.

The joined table will contain all records from both tables, and fill in NULLs for missing matches on either side.
The FULL OUTER JOIN keyword returns all records from the left table and from the right table.

The FULL OUTER JOIN keyword combines the result of both LEFT and RIGHT joins.

SELF JOIN

The SQL SELF JOIN is used to join a table to itself.

Advertisements