60

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

OM The Eternity
  • 15,694
  • 44
  • 120
  • 182
  • 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
  • 337,827
  • 72
  • 505
  • 443
19

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

Mark Byers
  • 811,555
  • 193
  • 1,581
  • 1,452