How can we differ LEFT OUTER JOIN vs Left Join

mysql join left-join outer-join
OM The Eternity picture OM The Eternity · May 11, 2010 · Viewed 22.2k times · Source

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

Answer

Daniel Vassallo picture Daniel Vassallo · May 11, 2010

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

Related questions

LEFT JOIN only first row

I read many threads about getting only the first row of a left join, but, for some reason, this does not work for me. Here is my structure (simplified of course) Feeds id | title | content ---------------------- 1 | Feed 1 | ... Artists artist_id | …

Read More
How to use mysql JOIN without ON condition?

Is it possible to write join query without ON statement? and how do these joins differ LEFT JOIN, RIGHT JOIN works.

Read More
SQL LEFT-JOIN on 2 fields for MySQL

I have a view A and a view B. In A I have a lot of information about some systems, like IP and port which I want to preserve all. In B I have just one information that I want …

Read More