This course is out of date and does not reflect our quality standards.

Check out a free preview of the full SQL Fundamentals course:
The "JOIN Exercise" Lesson is part of the full, SQL Fundamentals course featured in this preview video. Here's what you'd learn in this lesson:

There are several places in the course app where alphanumeric IDs are shown to users. Since users prefer referring to things by names, students in this exercise use JOIN to transform these references into records that are more user-friendly.

Get Unlimited Access Now