|
Toshkent axborot texnologiyalari universiteti kompyuter injinering fakulteti
|
bet | 10/19 | Sana | 16.05.2024 | Hajmi | 15,05 Mb. | | #237968 |
Bog'liq mal.B.2-ishSELECT
column_names [,... n]
FROM
Table_1 RIGHT JOIN Table_2 ON condition
12.3– rasm. 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
|
12.4 – rasm. Full outer join operatorining Venn diagrammasi orqali ko’rinishi
Ishni bajarish tartibi
SQL INNER JOIN operatori
So`rov: SELECT *FROM mutolachi INNER JOIN mutolachi_1 ONmutolachi.FISH= mutolachi_1.FISH;
Natija:
12.5 - rasm. Inner join qo’llanishi natijasi
2. LEFT JOIN operatori
So`rov: SELECT *FROM mutolachi left JOIN mutolachi_1 ON mutolachi.FISH= mutolachi_1.FISH;
Natija:
12.5 - rasm. Left join qo’llanishi natijasi
|
| |