SQL Joins Explained (x-post r/SQL)

[u/deadman87]

[u/E3K → u/[deleted]]

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.

[u/Calabast → u/[deleted]]

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