mysql> CREATE DATABASE asd;
Query OK, 1 row affected (0.48 sec)

mysql> SELECT table_name,table_comment FROM INFORMATION_SCHEMA.tables WHERE table_schema='asd';
Empty set (0.05 sec)

mysql> USE asd;
Database changed

mysql> CREATE TABLE ukraine (
    -> name CHAR(30) NOT NULL);
Query OK, 0 rows affected (0.84 sec)

mysql> INSERT INTO ukraine VALUES ('Kiev'),('Lvov'),('Kharkov'),('Poltava');
Query OK, 4 rows affected (0.15 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> SELECT * FROM ukraine;
+---------+
| name    |
+---------+
| Kiev    |
| Lvov    |
| Kharkov |
| Poltava |
+---------+
4 rows in set (0.00 sec)

mysql> CREATE TABLE russia (
    -> name CHAR(30) NOT NULL);
Query OK, 0 rows affected (0.25 sec)

mysql> INSERT INTO russia VALUES ('Moskva'),('Belgorod'),('Krasnodar'),('Sochi');
Query OK, 4 rows affected (0.11 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> SELECT * FROM russia;
+-----------+
| name      |
+-----------+
| Moskva    |
| Belgorod  |
| Krasnodar |
| Sochi     |
+-----------+
4 rows in set (0.00 sec)

Объединяю с помощью UNION

mysql> (SELECT * FROM ukraine) UNION (SELECT * FROM russia);
+-----------+
| name      |
+-----------+
| Kiev      |
| Lvov      |
| Kharkov   |
| Poltava   |
| Moskva    |
| Belgorod  |
| Krasnodar |
| Sochi     |
+-----------+
8 rows in set (0.00 sec)

mysql> (SELECT * FROM ukraine ORDER BY name) UNION (SELECT * FROM russia);
+-----------+
| name      |
+-----------+
| Kiev      |
| Lvov      |
| Kharkov   |
| Poltava   |
| Moskva    |
| Belgorod  |
| Krasnodar |
| Sochi     |
+-----------+
8 rows in set (0.00 sec)

mysql> (SELECT * FROM ukraine) UNION (SELECT * FROM russia ORDER BY name);
+-----------+
| name      |
+-----------+
| Kiev      |
| Lvov      |
| Kharkov   |
| Poltava   |
| Moskva    |
| Belgorod  |
| Krasnodar |
| Sochi     |
+-----------+
8 rows in set (0.00 sec)

mysql> (SELECT * FROM ukraine) UNION (SELECT * FROM russia) ORDER BY name;
+-----------+
| name      |
+-----------+
| Belgorod  |
| Kharkov   |
| Kiev      |
| Krasnodar |
| Lvov      |
| Moskva    |
| Poltava   |
| Sochi     |
+-----------+
8 rows in set (0.00 sec)

SELECT ....
UNION
SELECT ....
UNION
SELECT ....
UNION
SELECT ....

INSERT INTO `temp` SELECT .....;
INSERT INTO `temp` SELECT .....;
INSERT INTO `temp` SELECT .....;
INSERT INTO `temp` SELECT .....;

SELECT * FROM `temp`;