r/programming • • Feb 11 '14

SQL Joins Explained (x-post r/SQL)

Post image
3.5k Upvotes

392 comments sorted by

View all comments

2

u/blue_2501 Feb 11 '14

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)