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)
Dostları ilə paylaş: |