Query Quest PostgreSQL Course

Join tables

A JOIN combines rows from related tables. The ON condition says which values match. Here, completions.player_id points to players.id.

What you'll learn

INNER JOIN returns matching rows from both tables. One player can appear multiple times if they completed multiple quests.

Your mission

Show each completed quest title alongside the username of the player who completed it.

Enable JavaScript to run SQL in the interactive lesson.