Table_1 RIGHT JOIN Table_2 ON condition

Download 2.48 Mb.
bet	7/17
Sana	13.01.2024
Hajmi	2.48 Mb.
	#136474

1 2 3 4 5 6 7 8 9 10 ... 17

Bog'liq
ma\'lumotlar bazasi
Parallel tebranish konturini tadqiq qilish, file, 1-amaliyot topshiriq, 2-amaliy ish topshiriq, 6-topshiriq, “Barakali million” reklama aksiyasini o‘tkazish va unda ishtirok etish shartlari, elektronsxemalar Toʻychiyeva

Table_1 RIGHT JOIN Table_2 ON condition

Right outer join operatorining Venn diagraamsi orqali ko’rinishi

CROSS JOIN operatori 1 jadvaldagi xar bir element uchun 2 jadvaldagi elementlarni bog`lab chiqadi.

SQL CROSS JOIN operatorining sintaksisi quyidagi ko`rinishda bo`ladi:

SELECT_column_names_[,..._n]_FROM_Table_1_CROSS_JOIN_Table_2'>SELECT
column_names [,... n]
FROM
Table_1 CROSS JOIN Table_2

SQL FULL OUTER JOIN operatori 1 jadvaldagi xar bir element uchun 2 jadvaldagi elementlarni bog`lab chiqadi.

SQL FULL OUTER JOIN operatorining sintaksisi quyidagi ko`rinishda bo`ladi:

SELECT
column_names [,... n]
FROM
Table_1 FULL JOIN Table_2
ON condition

Full outer join operatorining Venn diagrammasi orqali ko’rinishi

Ishni bajarish tartibi

SQL INNER JOIN operatori

So`rov: SELECT *FROM zavod_xodimlari
INNER JOIN kon_xodimlari
ON zavod_xodimlari.FISH=kon_xodimlari.FISH;
Natija:

Inner join qo’llanishi natijasi
2. LEFT JOIN operatori
So`rov: SELECT * FROM zavod_xodimlari
LEFT JOIN kon_xodimlari
ON zavod_xodimlari.manzili = kon_xodimlari.manzili;
Natija:

Left join qo’llanishi natijasi

Download 2.48 Mb.

1 2 3 4 5 6 7 8 9 10 ... 17

Download 2.48 Mb.