Define full outer join * FULL OUTER JOIN combines the results of both left and right outer joins and returns all (matched or unmatched) rows from the tables on both sides of the join clause. Let's combine the same two tables using a full join Quotes: Clouds come floating into my life, no longer to carry rain or usher storm, but to add color to my sunset sky....||Believe with all of your heart that, you will do what you were made to do....|| "Life without faith in something is too narrow a space to live." ~George L Spaulding || "The most common way people give up their power is by thinking they don't have any." ~Alice Walker || "Happy are those who dream dreams and are ready to pay the price to make them come true." ~Leo Suenens