Put in order · SQL and MySQL course · Module 7: Joining tables (JOIN)
Joining books, authors and categories
Arrange the parts of a query joining three tables: the book, the author and the category (top to bottom):
Items to put in order
- INNER JOIN autorzy a ON k.autor_id = a.id
- INNER JOIN kategorie kat ON k.kategoria_id = kat.id;
- FROM ksiazki k
- SELECT k.tytul, a.nazwisko, kat.nazwa
You can check the correct answer by solving this task in the CodeWorlds game.