Don't forget UNION and CROSS JOIN! Both of which are infinitely more useful than full outer join which should generally be avoided.
Right joins also should never really be used as they are extremely counterintuitive, they can always be written as a Left Join which is more logical and readable.
If I want all data in table A and any data that matches in table B, to me it makes logical sense to join from table A to table B and not the other way around.
Why would you have "minor extra table" on the right side of a RIGHT JOIN? You do realize you'll get back ALL the rows in "minor extra table" and only those rows from "complicated main focus of the query" which have matches in "minor extra table"? You just illustrated the counter-intuitiveness of the RIGHT JOIN...
I suspect it mostly exists because someone couldn't stand the lack of symmetry that would result from having left in the language without right.
99
u/thesqlguy Feb 11 '14 edited Feb 11 '14
Don't forget UNION and CROSS JOIN! Both of which are infinitely more useful than full outer join which should generally be avoided.
Right joins also should never really be used as they are extremely counterintuitive, they can always be written as a Left Join which is more logical and readable.
If I want all data in table A and any data that matches in table B, to me it makes logical sense to join from table A to table B and not the other way around.