8 amaliy mashg‘uloti mavzu: Bir nеchta jadvallar birlashtirish, joinlar bilan ishlash Is

8.4 – rasm. Full outer join operatorining Venn diagrammasi orqali ko‘rinishi


Ishni bajarish tartibi

1. 
   SQL INNER JOIN operatori
   

Filmlar va reyting jadvallarini bir-biriga bog‘laymiz.
So‘rov: select * from filmlar
inner join reyting
on filmlar.film_id = reyting.film_id;
Natija:

8.5 - rasm. Inner join qo‘llanishi natijasi
2. LEFT JOIN operatori
So‘rov: select * from filmlar
left join reyting
on filmlar.film_id = reyting.film_id;
Natija:

8.6 - rasm. Left join qo‘llanishi natijasi

2. 
   RIGHT JOIN operatori
   

So‘rov: select * from filmlar
right join reyting
on filmlar.film_id = reyting.film_id limit 7;
Natija:

8.7 – rasm. Right join qo‘llanishi natijasi
3. CROSS JOIN operatori
So‘rov: select * from filmlar
cross join reyting
on filmlar.film_id = reyting.film_id limit 7;


Natija:

8.8– rasm. Cross join qo‘llanishi natijasi
4. FULL OUTER JOIN operatori:
So‘rov: select * from filmlar
cross join reyting
on filmlar.film_id = reyting.film_id limit 7;


Vazifalar

1. 
   Yuqorida ko‘rsatilganlardan foydalanib tanlangan variyantga muvofiq mavzu uchun MySQL da INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN, FULL OUTER JOIN va ON standat so‘zilari bilan ishlang.
   
2. 
   Bajarilgan ishlar haqida hisobot tayyorlang (1-2-ilovalarga qarang).
   

Nazorat savollari

1. 
   SQL tilidagi qanday JOIN larni bilasiz?
   
2. 
   INNER JOIN qanday vazifani bajaradi?
   
3. 
   LEFT JOIN qanday vazifani bajaradi?
   
4. 
   RIGHT JOIN qanday vazifani bajaradi?
   
5. 
   CROSS JOIN qanday vazifani bajaradi?
   
6. 
   FULL OUTER JOIN qanday vazifani bajaradi?