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

Database normalization is the cornerstone of database theory. Once a database is normalized, relationships between the data in multiple tables must be established.