How can we differ LEFT OUTER JOIN vs Left Join
MysqlJoinLeft JoinOuter JoinMysql Problem Overview
What is the difference between Left Join and Left Outer Join
?
Mysql Solutions
Solution 1 - Mysql
They are the same thing in MySQL. A LEFT JOIN
is a synonym or shorthand for LEFT OUTER JOIN
.
Solution 2 - Mysql
There is none. The keyword OUTER is optional. They mean the same.