How can we differ LEFT OUTER JOIN vs Left Join [du

问题:

This question already has an answer here:

• LEFT JOIN vs. LEFT OUTER JOIN in SQL Server 16 answers

What is the difference between Left Join and Left Outer Join?

回答1:

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

回答2:

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