CODEWITHSUNDEEP
mysql
user434909
user434909

Reputation: 153

Difference between left join and left outer join

I want to know if there is any difference in LEFT JOIN and LEFT OUTER JOIN in mySQL. And if there is no difference then why two different ways are there?

Thanks in advance...

Upvotes: 12

Views: 12600

Answers (1)

Dave
Dave

Reputation: 7025

They are the same, the only reason you would want to put the 'outer' in is for clarity I think, in order to clarify that the first table in the join does not require that it has something to join to in the second table.

This is a good article on wikipedia covering some of this.

Functionally they are the same.

Upvotes: 26

Related Questions