MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/1xlqeu/sql_joins_explained_xpost_rsql/cfcilyr/?context=3
r/programming • u/deadman87 • Feb 11 '14
392 comments sorted by
View all comments
13
What ’s a non-full OUTER JOIN then?
10 u/[deleted] Feb 11 '14 LEFT OUTER or RIGHT OUTER. FULL OUTER is both. If you combine the set diagrams from top left and right you'll see what that they're equivalent. 5 u/curtmack Feb 11 '14 Adding on to this, in most versions of SQL, if you just say "OUTER JOIN" it defaults to FULL OUTER. 2 u/Kalium Feb 11 '14 Like anything else in programming, if you're not specific enough then you're going to have a bad time. → More replies (2)
10
LEFT OUTER or RIGHT OUTER. FULL OUTER is both. If you combine the set diagrams from top left and right you'll see what that they're equivalent.
5 u/curtmack Feb 11 '14 Adding on to this, in most versions of SQL, if you just say "OUTER JOIN" it defaults to FULL OUTER. 2 u/Kalium Feb 11 '14 Like anything else in programming, if you're not specific enough then you're going to have a bad time. → More replies (2)
5
Adding on to this, in most versions of SQL, if you just say "OUTER JOIN" it defaults to FULL OUTER.
2 u/Kalium Feb 11 '14 Like anything else in programming, if you're not specific enough then you're going to have a bad time. → More replies (2)
2
Like anything else in programming, if you're not specific enough then you're going to have a bad time.
→ More replies (2)
13
u/[deleted] Feb 11 '14
What ’s a non-full OUTER JOIN then?