I know this won't be of much use to you hardened SQL warriors out there, but I just found this link which I found very helpful in explaining joins to one of our developers.
Coding Horror: A Visual Explanation of SQL Joins
Coding Horror: A Visual Explanation of SQL Joins
Comment