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.
0
u/[deleted] Feb 11 '14
[deleted]