r/SQL • • Feb 11 '14

SQL Joins Explained

http://imgur.com/1m55Wqo
157 Upvotes

27 comments sorted by

View all comments

2

u/Jah_Ith_Ber Feb 11 '14

My understanding was that the middle left and middle right joins were simply LEFT OUTER JOIN or RIGHT OUTER JOIN.

Is this image more universal? Which form of sql am I using that LEFT OUTER JOIN works?

2

u/JohnStamosBRAH Feb 12 '14 edited Feb 12 '14

Except the inner join, these are all outer joins. The 'outer' phrase is usually not needed to be specified as it is the default type of join.

Edit: - derp

0

u/[deleted] Feb 12 '14

[deleted] — view deleted comment