Union All

UNION ALL can be used to combine results from multiple SELECT statements.

1. cr> select name from photos
2. ... union all
3. ... select name from countries
4. ... union all
5. ... select name from photos
6. ... order by name;
7. +--------------+
8. | name         |
9. +--------------+
10. | Austria      |
11. | Berlin Wall  |
12. | Berlin Wall  |
13. | Eiffel Tower |
14. | Eiffel Tower |
15. | France       |
16. | Germany      |
17. | South Africa |
18. | Turkey       |
19. +--------------+
20. SELECT 9 rows in set (... sec)