FULL OUTER JOIN returns all rows from the left table and from the right table and combines the data of both LEFT and RIGHT joins.