A LEFT OUTER JOIN (or simply LEFT JOIN) in MySQL is used to retrieve all records from the "left ... India', 'Odisha', 'BBSR'); -- We can also use the LEFT JOIN keyword as shown in the below SQL Query, ...