Joining tables with JOIN
Merge the columns of the source tables seasons and series, then output all the seasons of the IT Crowd series to the resulting table using the JOIN operator.
Note
We assume that you already created tables in step Creating a table and populated them with data in step Adding data to a table.
SELECT
sa.title AS season_title, -- sa and sr are "join names",
sr.title AS series_title, -- table aliases declared below using AS.
sr.series_id, -- They are used to avoid
sa.season_id -- ambiguity in the column names used.
FROM
seasons AS sa
INNER JOIN
series AS sr
ON sa.series_id = sr.series_id
WHERE sa.series_id = 1
ORDER BY -- Sorting of the results.
sr.series_id,
sa.season_id -- ORDER BY sorts the values by one column
; -- or multiple columns.
-- Columns are separated by commas.
COMMIT;