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

Readers with their loan dates

Click the elements in the order in which we build a query with LEFT JOIN joining czytelnicy with wypozyczenia:

Items to click

  • ;
  • FROM czytelnicy c
  • SELECT c.nazwisko, w.data_wypozyczenia
  • LEFT JOIN wypozyczenia w
  • ON w.czytelnik_id = c.id

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