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.