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.