Question: what is difference between left join and left outer join in mysql?
Answer: LEFT JOIN / LEFT OUTER JOIN : returns all rows from the left table, even if there are no matches in the right table. RIGHT JOIN / RIGHT OUTER JOIN : returns all rows from the right table, even if there are no matches in the left table.