A simple and (hopefully) realistic demonstration of a left outer join query.
The problem: You have separate tables for billing addresses and shipping addresses. You want to send mail--of both physical and digital persuasions--to all of your customers. But how?!?