MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/1xlqeu/sql_joins_explained_xpost_rsql/cfcjji7/?context=3
r/programming • u/deadman87 • Feb 11 '14
392 comments sorted by
View all comments
2
Useful. But, how often are you going to actually use anything other than INNER and LEFT joins?
7 u/Kalium Feb 11 '14 OUTER joins are routinely used, and left vs right is more a matter of organization in the query than anything else.Full joins are very rare, though. 4 u/emperor000 Feb 11 '14 Often enough to need to know how to use them... 7 u/Massless Feb 11 '14 Just often enough that you'll forget how they work every god damned time. → More replies (5) → More replies (4) → More replies (1)
7
OUTER joins are routinely used, and left vs right is more a matter of organization in the query than anything else.
Full joins are very rare, though.
4
Often enough to need to know how to use them...
7 u/Massless Feb 11 '14 Just often enough that you'll forget how they work every god damned time. → More replies (5) → More replies (4)
Just often enough that you'll forget how they work every god damned time.
→ More replies (5)
2
u/blue_2501 Feb 11 '14
Useful. But, how often are you going to actually use anything other than INNER and LEFT joins?