How can we differ LEFT OUTER JOIN vs Left Join [duplicate]

mysql join left-join outer-join

They are the same thing in MySQL. A LEFT JOIN is a synonym or shorthand for LEFT OUTER JOIN.

mysql join left-join outer-join

There is none. The keyword OUTER is optional. They mean the same.

CodeHunter