Composing a Query

Selecting Tables and Queries

Adding one or more Tables to a Query

Utilizing Roadmaps

Pitfalls

Combining Tables

Pitfalls when picking multiple tables

Selecting Columns

Table Prefixes for Columns

Table and Column Aliases

When do you use aliases?

Building Queries Iteratively

Using an Existing Query inside another Query