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

Loan report with category

Join four shelves - from the loan, through the reader and the book, all the way to the category.

Task

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