Coding task · SQL and MySQL course · Module 7: Joining tables (JOIN)

All readers and their loans

Show all readers, even those without a single loan, using a LEFT JOIN.

Task

Write a query that shows the nazwisko of every reader and the data_wypozyczenia from the wypozyczenia table. Use LEFT JOIN so that readers with no loans are shown too. Aliases: czytelnicy c, wypozyczenia w, condition w.czytelnik_id = c.id.