Union AllΒΆ

UNION ALL can be used to combine results from multiple SELECT statements. For further information on the syntax and usages see UNION ALL.

cr> select name from photos
... union all
... select name from countries
... union all
... select name from photos
... order by name;
+--------------+
| name         |
+--------------+
| Austria      |
| Berlin Wall  |
| Berlin Wall  |
| Eiffel Tower |
| Eiffel Tower |
| France       |
| Germany      |
| South Africa |
| Turkey       |
+--------------+
SELECT 9 rows in set (... sec)