In an effort to remember what it's like to write SQL queries I found this link on visualizing JOINs. I found it very helpful; hope you do too.
Sorry guys, try this: http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html