The FULL OUTER JOIN returns the result of the combination of left and right outer joins.

Syntax:

 SELECT <em>columnList </em>FROM <em>table1 FULL OUTER</em> JOIN <em>table2 </em>ON t<em>able1.columnName </em>= <em>table2.columnName</em>;

Example:

SELECT P_ID, NAME, AMOUNT
 
FROM PERSONS
 
FULL OUTER JOIN ORDERS
 
ON PERSONS.P_ID = ORDERS.PERSON_ID;

Output:

P_ID	NAME	AMOUNT
1	jai	-
2	sandy	30000
2	sandy	22000
3	deepak	23000
3	deepak	25000
4	Ashish	-