• SELECT column_names [,... n] FROM Table_1 LEFT JOIN Table_2 ON condition 8.2 – rasm. Left outer join
  • 8.3– rasm. Right outer join
  • 8.4 – rasm. Full outer join operatorining Venn diagrammasi orqali ko’rinishi SELECT column_names [,... n] FROM
  • So`rov: SELECT *FROM student INNER JOIN teacher ON student.oylik_maoshi=teacher.oylik_maoshi;
  • SELECT column_names [,... n]




    Download 0,99 Mb.
    Pdf ko'rish
    bet7/13
    Sana14.05.2024
    Hajmi0,99 Mb.
    #232373
    1   2   3   4   5   6   7   8   9   10   ...   13
    SELECT
    column_names [,... n]
    FROM
    Table_1 INNER JOIN 
    Table_2
    ON condition
    8.1 – rasm. Inner join 
    operatorining Venn diagrammasi orqali ko’rinishi


    1. SQL LEFT JOIN operatorining 1jadval va 2 jadvalning 1 jadvalda mos 
    elementlarini qo`shadi.
    SQL LEFT JOIN operatorining sintaksisi quyidagi ko`rinishda bo`ladi:
    SELECT
    column_names [,... n]
    FROM
    Table_1 LEFT JOIN 
    Table_2
    ON condition
    8.2 – rasm. Left outer join 
    operatorining Venn diagrammasi orqali ko’rinishi
    2. SQL RIGHT JOIN operatorining 2 jadval va 1 jadvalning 2 jadvalda mos 
    elementlarini qo`shadi.
    SQL RIGHT JOIN operatorining sintaksisi quyidagi ko`rinishda bo`ladi:
    8.3– rasm. Right outer join 
    operatorining Venn diagraamsi orqali ko’rinishi


    3. 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:
    4. 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:
    8.4 – rasm. Full outer join 
    operatorining Venn diagrammasi orqali ko’rinishi
    SELECT
    column_names [,... n]
    FROM
    Table_1 CROSS JOIN Table_2


    Ishni bajarish tartibi
    1.
    SQL INNER JOIN operatori
    So`rov: SELECT *FROM student 

    INNER JOIN teacher
    ON student.oylik_maoshi=teacher.oylik_maoshi;

    Download 0,99 Mb.
    1   2   3   4   5   6   7   8   9   10   ...   13




    Download 0,99 Mb.
    Pdf ko'rish