Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

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 functions.