Quote Originally Posted by pendell View Post
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.
Yes. Generally the most important table is mentioned first; so in a case where you want everything from one of the tables in a join, typically that table will be on the left.