Coding task · SQL and MySQL course · Module 9: Indexes and normalization

Fetch the category name via JOIN

After the 3NF split we keep the category name once, in the kategorie table. To show it next to the book title, we join the tables with JOIN.

Task

Write a query that retrieves tytul from the ksiazki table and nazwa from the kategorie table, joining them on the kategoria_id column (ksiazki.kategoria_id = kategorie.id). Use JOIN.