Understanding JOINs in MySQL and Other Relational Databases

OUTER JOIN (or FULL OUTER JOIN) Our last option is the OUTER JOIN which returns all records in both tables regardless of any match. Where no match exists, the missing side will contain NULL. OUTER JOIN is less useful than INNER, LEFT or RIGHT and it’s ...

www.sitepoint.com