1. User's Guide
  2. Case Studies
  3. Case 3: Joining SQL Server Tables

3.7 Case 3: Joining SQL Server Tables

Demonstration joining SQL Server tables.

Case 3 demonstrates the following:

  • Joins between SQL Server tables
  • Subselects

The query retrieves information from three SQL Server tables and relates the employees to their department name and salary grade, but only for those employees earning more than the average salary.

Parent topic: Case Studies