What is the difference between Left Join and Left Outer Join?
asked May 11, 2010 at 9:50
-
6Well not an exact duplicate because that was for SQL Server, but it's basically the same answer.– Mark ByersCommented May 11, 2010 at 9:55
-
1@OM The Eternity: enable Javascript in your browser, while you are typing the question, you could see other questions same as yours– HaoCommented May 11, 2010 at 9:56
-
@Hao LOL u r browser Hacker!!! and my mind hacker as well how did u come to know that ?? :)– OM The EternityCommented May 11, 2010 at 10:24
Add a comment
|
2 Answers
They are the same thing in MySQL. A LEFT JOIN is a synonym or shorthand for LEFT OUTER JOIN.
answered May 11, 2010 at 9:51
There is none. The keyword OUTER is optional. They mean the same.
answered May 11, 2010 at 9:51
