|
Table_1 RIGHT JOIN Table_2 ON condition
|
| bet | 7/17 | | Sana | 13.01.2024 | | Hajmi | 2,48 Mb. | | #136474 |
Bog'liq ma\'lumotlar bazasiTable_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
|
| |
