Use of SQL FULL OUTER JOIN

 Use of SQL FULL OUTER JOIN. The following command shows how to join common data use SQL FULL OUTER JOIN.

 

SELECT table1.*, table2.column, table2.column
FROM table1
FULL OUTER JOIN table2
ON table1.column = table2.column;

Example:

SELECT employees.*, payments.date, payments.amount
FROM employees
FULL OUTER JOIN payments
ON employees.id = payments.employee_id;