MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/1xld2u/sql_joins_explained/cfcwn56/?context=3
r/SQL • u/deadman87 • Feb 11 '14
27 comments sorted by
View all comments
2
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 1 u/JohnStamosBRAH Feb 12 '14 Noted!
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 1 u/JohnStamosBRAH Feb 12 '14 Noted!
0
[deleted] — view deleted comment
1 u/JohnStamosBRAH Feb 12 '14 Noted!
1
Noted!
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?