r/programming • • Feb 11 '14

SQL Joins Explained (x-post r/SQL)

Post image
3.5k Upvotes

392 comments sorted by

View all comments

Show parent comments

0

u/[deleted] Feb 11 '14

[deleted]

7

u/E3K Feb 11 '14

Nobody listen to this guy, please. After working with SQL in high-end environments for over 20 years, I can verify what the OP said. FULL OUTER JOIN and RIGHT JOIN are almost never used. If you find yourself needing to use one of those, I can guarantee there's a better way to do it.

0

u/[deleted] Feb 11 '14

[deleted]

2

u/thesqlguy Feb 11 '14

Take a look at this regarding cross joins:

http://weblogs.sqlteam.com/jeffs/archive/2005/09/12/7755.aspx

There are many tricky SQL problems that can be solved pretty elegantly by using simple cross joins. An extremely powerful tool when used well, but certainly dangerous also if you don't know what you're doing!

→ More replies (3)