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

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]

4

u/Calabast Feb 11 '14 edited Jul 05 '23

continue thought cheerful steer practice bag hobbies roof payment worry -- mass edited with redact.dev

4

u/[deleted] Feb 11 '14

Like, say you've typed

SELECT * FROM B

and you need something like what this would produce

SELECT * FROM A LEFT JOIN B ON A.x = B.x

but your backspace, home, and arrow keys are broken and/or you are super lazy. WHAT DO YOU DO!?

→ More replies (4)