4- laboratoriya ishi

RIGHT JOIN operatori

So‘rov: SELECT *FROM zavod_xodimlari RIGHT JOIN kon_xodimlari

ON zavod_xodimlari.oyligi = kon_xodimlari.oyligi;

Natija:

5. 
   – rasm. Right join qo‘llanishi natijasi.
   

2. CROSS JOIN operatori

So‘rov: SELECT *FROM zavod_xodimlari CROSS JOIN kon_xodimlari

ON zavod_xodimlari.ish_staji = kon_xodimlari.ish_staji;

Natija:

5. 
   – rasm. Cross join qo‘llanishi natijasi.
   

2. FULL OUTER JOIN operatori:

So‘rov: SELECT *FROM zavod_xodimlari FULL OUTER JOIN kon_xodimlari

ON zavod_xodimlari.FISH=kon_xodimlari.FISH;

Natija:
12.1– jadval. Full outer join qo‘llanishi natijasi

Xod im_id	FISH	manzili	lavozimi	Ish_st aji	oyligi
1	Eshbotayev Sardor	Lalmikor	Tegirmon mashinisti	10	7000000
2	Abirov Dilshod	Marjonbuloq	Labaratoriya mudiri	15	9000000
3	Narzullayev Oybek	Lalmikor	Boyitish ishlari boyich	15	10000000
4	Soliyev Elmurod	Marjonbuloq	Xavsizlik ishlari	10	7000000
5	Muhammadiyev Begzod	Olmali	Gruz mashinisti	12	8000000
6	Duvlonov Bunyod	Lalmikor	Ekalogiya va atrof muhitga javobgar	16	10000000
7	Shobotayev Shahzod	Oqtosh	Loyiha ishlari muhandis	14	9000000
1	Aliyev Sarvar	Lalmikor	Burgulash mashinisti	10	7000000
2	Berdiyorov Bunyod	Mullabuloq	Bosh loyihachi	15	9000000
4	Mamirov Shahzod	Gobdin	Gruz mashinisti	12	8000000
5	Abirqulov Alisher	Moltob	Tashish mashinisti	10	7000000

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?
   

FULL OUTER JOIN qanday vazifani bajaradi?