SQL FULL JOIN


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

SELECT table1.column1, table2.column2...
FROM table1
FULL JOIN table2
ON table1.common_field = table2.common_field;

Example

table_A

AM
1m
2n
4o

table_B

AN
2p
3q
5r
Output
AMAN
2n2p
1m--
4o--
--3q
--5r

Share this article on