59

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

OM The Eternity
  • 14,916
  • 40
  • 117
  • 180
  • 6
    Well not an exact duplicate because that was for SQL Server, but it's basically the same answer. – Mark Byers May 11 '10 at 09:55
  • 1
    @OM The Eternity: enable Javascript in your browser, while you are typing the question, you could see other questions same as yours – Hao May 11 '10 at 09:56
  • @Hao LOL u r browser Hacker!!! and my mind hacker as well how did u come to know that ?? :) – OM The Eternity May 11 '10 at 10:24

2 Answers2

79

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

Daniel Vassallo
  • 326,724
  • 71
  • 495
  • 436
19

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

Mark Byers
  • 767,688
  • 176
  • 1,542
  • 1,434