FULL OUTER JOIN: is used when retrieving data from multiple tables and will return both table records, matching and non-matching.