I was about to write this exact same article, but focusing on RIGHT OUTER JOINs... Seeing those in a query just makes me cringe! EVERY outer join can be expressed as a LEFT OUTER. ROJ's are completely useless...