[go: up one dir, main page]

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