Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

JOINs in MS SQL Server

Introduction
2. Get to know the WorkshopWorkers table
Dictionary database
Summary

Instruction

We'll start with the WorkshopWorkers table from the Sesame Brothers Workshop.

Exercise

The WorkshopWorkers table consists of a few columns:

  • Id – the ID of a given worker,
  • Name – the first and last name of a given worker,
  • Specialization – a given worker's specialization,
  • MasterId – the ID of a given worker's supervisor,
  • Experience – number indicating a given worker's years of experience, and
  • ProjectId – the ID of the project a given worker is currently assigned.

Show all workers' names together with the names of their direct supervisors. Rename columns to ApprenticeName and MasterName, respectively.

Stuck? Here's a hint!

You have to give an alias to either both or at least one table. Type:

SELECT
  Apprentice.Name ApprenticeName,
  Master.Name MasterName
FROM WorkshopWorkers Apprentice
JOIN WorkshopWorkers Master
  ON Apprentice.MasterId = Master.Id