|The Message text:
This email was created by [your name] who thought you would be interested in the following Article:
"JOIN Instead of Repeating a Subquery"
Rather than use multiple subqueries to extract TOP 1 data, this shows you how to use a single TOP 1 JOIN.
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!