A LEFT OUTER JOIN (or simply LEFT JOIN) in MySQL is used to retrieve all records from the "left" table, and the matched records from the "right" table. If there is no match, NULL values are returned ...