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)
