SQL Full Outer Join Examples

To retrieve all the records from left as well as right table unless the records have matching relations in each row you can use SQL FULL OUTER JOIN.

You can consider the examples of last two articles about left outer join and right outer join, in which left outer join retrieves all records from the left table and as all records of right table in right outer join along with null values for the columns having no matching records in any tuple. To retain all the records of left as well as right table along with null values for non matching rows displaying the combination of results of left outer and right outer join, FULL OUTER JOIN is the best solution.

SQL FULL Outer Join Example

SELECT			A.AU_FNAME, 
				A.AU_LNAME, P.PUB_NAME
FROM			AUTHORS A 
FULL OUTER JOIN PUBLISHERS P
ON				A.CITY = P.CITY
ORDER BY		A.AU_LNAME, A.AU_FNAME

Result

Above output retrieved from the sql full outer join query is the exact combination of both the left as well as right join outputs.

Continue to next tutorial: SQL Cross Join Cartesian product Examples to learn the implementation of cartesian product using cross join in a sql query.