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

Squash the dangers lurking in your SQL queries by setting parameters by way of parameterized queries.