Read this SQL tutorial to learn when to use Pick, Sign up for, subselects and UNION to entry multiple tables with a solitary statement.
The post How to query numerous tables in SQL appeared to start with on TechRepublic.
How to query multiple tables in SQL