Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

SQL Basics I: Data Queries —covers database terminology and the four basic query types. SQL Basics: SELECT statement options —covers the SELECT statement in detail and explains aggregate ...