SQL FULL OUTER JOIN
SQL FULL JOIN or FULL OUTER JOIN returns rows from both left and right tables, with the matching rows from both tables where available. If there is no match, the missing side will have null values.
Home »
full outer join
SQL Server JOINS
A JOIN clause is used to combine two or more related tables. Tables are related to each other using foreign key constraints.