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.