Mavlonov Xamdam

+----------+--------------+----------+-------------+---------+-----------+
| Aziz | Ahmedov | Akmaljon | Fergana | Quvasoy | 901429851 |
| Arslon | Asliddinov | Akbarjon | Fergana | Qoqon | 911423151 |
| Bekmurod | Bakirov | Bahodir | Qashqadaryo | Qarshi | 931449872 |
| Bahrom | Bakirov | Behzod | Qashqadaryo | Kitob | 991827319 |
| Elyor | Ergashaliyev | Bobur | Namangan | Chust | 945901298 |
+----------+--------------+----------+-------------+---------+-----------+ 5 
rows in set (0.00 sec)

mysql> select*from sotuvchilar;
+-------------+---------------+----------------+----------------------+-----------------+
| familyasi | ismi | otasining_ismi | kelib_tushgan_sanasi | tugilgan_sanasi
|

---

+-------------+---------------+----------------+----------------------+-----------------+
| Karimov | Muhammaddiyor | Akmaljon | 2021-04-21 | 2004 |
| Ahmedov | Oybek | Akram | 2020-08-19 | 2003 |
| Ahmedov | Akmal | Akbar | 2020-03-20 | 2003 |
| Asliddinov | Kamol | Davlatjon | 2021-09-18 | 2000 |
| Abdukarimov | Asliddin | Akbarali | 2022-04-30 | 2004 |
+-------------+---------------+----------------+----------------------+-----------------+ 5 
rows in set (0.00 sec)

mysql> select ismi,familyasi,tugilgan_sanasi from sotuvchilar
-> union
-> select ism,familaya,manzil from xaridorlar;
+---------------+--------------+-----------------+
| ismi | familyasi | tugilgan_sanasi |
+---------------+--------------+-----------------+