Coding task · SQL and MySQL course · Module 7: Joining tables (JOIN)
All categories and their books
Show every category, even an empty one - with no single book - thanks to LEFT JOIN.
Task
Write a query that shows the name of each category (the nazwa column) and the tytul of a book in that category. Use LEFT JOIN so that categories without books are shown too. Aliases: kategorie kat, ksiazki k, condition k.kategoria_id = kat.id.