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

Want faster SQL queries? Here are nine best practices for writing SQL queries that work like a charm (or at least, like they should).