mention right joins, make it clear we're talking about left outer join as the bigger issue