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

Solution 1:

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

Solution 2:

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