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

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.