http://www.onjava.com/pub/a/onjava/2004/01/07/SQLJoins.html

A join construct helps you effectively use select statements to mine relational databases. This article examines syntax, surprises, and rules of thumb for the use of joins. Jan. 7, 2004