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.