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

Loans: reader and title

Join three shelves at once - wypozyczenia, czytelnicy and ksiazki - to turn numbers into a readable report.

Task

Write a query that shows data_wypozyczenia, the reader's nazwisko and the tytul of the borrowed book. Join wypozyczenia w with czytelnicy c (on w.czytelnik_id = c.id) and with ksiazki k (on w.ksiazka_id = k.id) using INNER JOIN.