A DBA I worked with had a good one-- just asked a question that was the textbook problem a left join solved.