Stack Overflow


This bears up with my own experience: Inner join is more efficient than either right or left join, but right or left join are, in the abstract, interchangeable. Which one is more efficient depends entirely on the tables you are joining. However, I notice that programmers seem to prefer left join as a matter of convention; I have seen many, many left joins in my time but hardly ever a right join outside a textbook.

Respectfully,

Brian P.