SQL Oracle PHP Java JSP JDBC MORE

SQL FULL OUTER JOIN with Example


In SQL the FULL OUTER JOIN is used to Select all records when there is a match in either left or right table.

FULL OUTER JOIN Syntax

SELECT column_name(s)
FROM table1
FULL OUTER JOIN table2 ON table1.column_name = table2.column_name;

left join