http://www.w3schools.com/sql/sql_join_full.asp

This join combines left outer join and right after join. It returns row from either table when the conditions are met and returns null value when there is no match. Example - Select * From Table1 FULL Join Table2 ON table1.ColumnName = Table2.ColumnName