full outer join clause in SQL

Suppose that you want to perform a full outer join of two tables: A and B. The following illustrates the syntax of the FULL OUTER JOIN:
```
SELECT * FROM A
FULL [OUTER] JOIN B on A.id = B.id;
```
In this syntax, the OUTER keyword is optional.
The full outer join combines the results of both left join and right join.
If the rows in the joined table do not match, the full outer join sets NULL values for every column of the table that does not have the matching row.
If a row from one table matches a row in another table, the result row will contain columns populated from columns of rows from both tables.
```
SELECT
	employee_name,
	department_name
FROM
	employees e
FULL OUTER JOIN departments d 
        ON d.department_id = e.department_id;
```
Home