Put in order · SQL and MySQL course · Module 8: Subqueries
Titles of two categories with UNION ALL
Arrange (top to bottom) the lines of the query joining two lists of titles with the UNION ALL operator:
Items to put in order
- UNION ALL
- SELECT tytul FROM ksiazki WHERE kategoria_id = 1
- SELECT tytul FROM ksiazki WHERE kategoria_id = 2;
You can check the correct answer by solving this task in the CodeWorlds game.