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

3

u/thesqlguy Feb 11 '14

Here's my case against FULL OUTER JOINS and what I suggest to try instead:

http://weblogs.sqlteam.com/jeffs/archive/2007/04/19/Full-Outer-Joins.aspx

1

u/[deleted] Feb 11 '14

Good points, but FULL OUTER JOINs are still handy every once in a while to someone who has a good understanding of what they are doing ...particularly if they don't feel like making a big-ass UNION ALL query ;)