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.