Mavlonov Xamdam

9.Har bir talaba o’ziga berilgan predmet soha mavzusi 
bo’yicha JOIN operatorilaridan foydalanib so’rovlar 
yaratishi va natijasi bilan ko’rsatib o’tishi kerak. 



mysql> select X.ism,J.sana from XODIM X
-> INNER JOIN JARAYON J
-> ON x.id=j.id;
+---------------+------------+

---

| ism | sana |
+---------------+------------+
| Elyor | 2020-11-20 |
| Bekmurod | 2020-12-20 |
| Akbar | 2020-06-20 |
| Aziz | 2020-09-20 |
+---------------+------------+
4 rows in set (0.00 sec)

mysql> select X.ism,J.sana from XODIM X
-> LEFT JOIN JARAYON J
-> ON x.id=j.id;
+---------------+------------+
| ism | sana |
+---------------+------------+
| Elyor | 2020-11-20 |
| Bekmurod | 2020-12-20 |
| Akbar | 2020-06-20 |
| Aziz | 2020-09-20 |
+---------------+------------+
4 rows in set (0.00 sec)

mysql> select X.ism,J.sana from XODIM X
-> left JOIN JARAYON J
-> ON x.id=j.id;
+---------------+------------+
| ism | sana |
+---------------+------------+

| Elyor | 2020-11-20 |
| Bekmurod | 2020-12-20 |
| Akbar | 2020-06-20 |
| Aziza | 2020-09-20 |
+---------------+------------+
4 rows in set (0.00 sec)

---