Nevermind, I don't think it matters that I use the IN clause, but to clarify anyway... I was able to use an outer join when the a1.code used an explicit comparison (=), but when I use an IN clause (a1.code IN ('this', 'or', 'that')), then I can't use the outer join.