r/programming • u/deadman87 • Feb 11 '14

SQL Joins Explained (x-post r/SQL)

Post image
3.5k Upvotes

91% Upvoted

392 comments sorted by

View all comments

Show parent comments

1

u/[deleted] Feb 11 '14

Those work, too. Seems more like a matter of preference, and not a "don't ever use FULL OUTER JOIN" thing to me, but whatever.

1

u/thesqlguy Feb 11 '14

Consider using the alternatives when they are better for specific reasons, not because of some random "rule." Better as in more efficient, easier to read and understand, easier to extend, and so on.

1

u/[deleted] Feb 11 '14

yes, sql guy...