full outer join in sql server

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.