Querying Multiple Tables

Restriction: This topic applies to Windows environments only.

Good database design usually results in a database with multiple tables related to each other by the values in certain columns. Even though the data is stored in separate tables, you will often want to see it in a single result. When you combine the data from two or more tables into a single result, you create a join.