"Conceptually, a full outer join combines the effect of applying both left and right outer joins. Where records in the FULL OUTER JOINed tables do not match, the result set will have NULL values for every column of the table that lacks a matching row."

http://en.wikipedia.org/wiki/Join_(SQL)#Full_outer_join