I've used this same concept in subqueries for a very long time. Doing this allows me to "dive in" and get other values from the joined table, rather than just the thing that we're getting the most of.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - "I kept looking for somebody to solve the problem. Then I realized... I am somebody!" -- Author Unknown -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.