SQL JOIN

For a quick note on INNER/OUTER/LEFT/RIGHT JOIN available in SQL Server (I have no idea about its availability on other databases), see

http://www.devx.com/dbzone/Article/17403/0/page/4
http://www.w3schools.com/sql/sql_join.asp