Click in order · SQL and MySQL course · Module 7: Joining tables (JOIN)

Joining ksiazki with autorzy step by step

Click the elements in the order in which we build a query joining the ksiazki table with autorzy:

Items to click

  • ON k.autor_id = a.id
  • SELECT k.tytul, a.nazwisko
  • FROM ksiazki k
  • ;
  • INNER JOIN autorzy a

You can check the correct answer by solving this task in the CodeWorlds game.