Coding task · SQL and MySQL course · Module 7: Joining tables (JOIN)
Book, author and category
Throw two bridges at once - join ksiazki with autorzy and with kategorie.
Task
Write a query that shows the book's tytul, the author's nazwisko and the category name (nazwa). Join ksiazki (alias k) with autorzy (alias a) on k.autor_id = a.id and with kategorie (alias kat) on k.kategoria_id = kat.id, using INNER JOIN.