Coding task · SQL and MySQL course · Module 8: Subqueries

Combine titles with duplicates

Use UNION ALL to keep all rows from both queries, including repetitions.

Task

Write a query that uses UNION ALL to combine the titles of books from the category with kategoria_id = 1 and the titles of books from the category with kategoria_id = 2. In both queries select the tytul column from the ksiazki table.