Difference between left join and left outer join

tags:

mysql

views:

answers:

+2 Q:

Difference between left join and left outer join

Hello,

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...

+5 A:

You should check this out:

A Visual Explanation of SQL Joins

Sarfraz 2010-10-15 07:37:04

@Jeff nice article

org.life.java 2010-10-15 07:39:45

@org.life.java, Sarfraz: Indeed, I've favourited that.

Dave 2010-10-15 07:42:56

1+ 13 more to go.

org.life.java 2010-10-15 07:44:01

@org.life.java: Indeed, thanks :P

Sarfraz 2010-10-15 07:47:53

Indeed, indeed. :P

Dave 2010-10-15 09:20:21

+10 A:

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.

Dave 2010-10-15 07:38:21