← Learn/Part 2 · Multiple tables

The data is spread across tables — time to bring it back together in the answer. JOIN is the most important skill after SELECT: without it a relational database is useless. Here the tables "come alive": who bought what, revenue by category, who ordered nothing. Lessons 1–5 use full table names for clarity, lesson 6 introduces aliases, and after that we work with them.