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

Fastest Way to Check if MYSQL Table Exists in PHP. Dynamic PHP pages give you the option to choose a MySQL table dynamically from which to query.