• Table_1 CROSS JOIN Table_2
  • So`rov: SELECT *FROM student INNER JOIN teacher ON student.oylik_maoshi=teacher.oylik_maoshi; Natija: 8.5 - rasm. Inner join
  • 8.6 - rasm. Left join qo’llanishi natijasi RIGHT JOIN operatori So`rov: SELECT *FROM student RIGHT JOIN teacher
  • So`rov : SELECT *FROM student CROSS JOIN teacher ON student.oylik_maoshi = teacher.oylik_maoshi; Natija: 8.8– rasm. Cross join
  • Zafar-mb-7-8 pdf




    Download 3,3 Mb.
    bet7/17
    Sana14.05.2024
    Hajmi3,3 Mb.
    #232380
    1   2   3   4   5   6   7   8   9   10   ...   17
    Bog'liq
    qayta o\'qish mb7-12

    8.3– rasm. Right outer join operatorining Venn diagraamsi orqali ko’rinishi

    1. 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
    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 Ishni bajarish tartibi

    1. SQL INNER JOIN operatori

    So`rov:_SELECT_*FROM_student__INNER_JOIN_teacher_ON_student.oylik_maoshi=teacher.oylik_maoshi;_Natija:__8.5_-_rasm._Inner_join'>So`rov: SELECT *FROM student
    INNER JOIN teacher
    ON student.oylik_maoshi=teacher.oylik_maoshi; Natija:

    8.5 - rasm. Inner join qo’llanishi natijasi

    1. LEFT JOIN operatori

    So`rov: SELECT * FROM student
    LEFT JOIN teacher
    ON student.telefon_raqami = teacher.telefon_maoshi; Natija:

    8.6 - rasm. Left join qo’llanishi natijasi

    1. RIGHT JOIN operatori

    So`rov: SELECT *FROM student
    RIGHT JOIN teacher
    ON student.oylik_maoshi = teacher.oylik_maoshi; Natija:

    8.7 – rasm. Right join qo’llanishi natijasi

    1. CROSS JOIN operatori

    So`rov: SELECT *FROM student
    CROSS JOIN teacher
    ON student.oylik_maoshi = teacher.oylik_maoshi; Natija:

    8.8– rasm. Cross join qo’llanishi natijasi
    3.Full outer operetori
    So’rov:select*from teacher right join student on teacher.oylik_maoshi =student.oylik_maoshi union select*from teacher left join student on teacher.ismi=student.ismi;
    Natija:

    8.9-rasm.Full outer join ning qo’llanishi;

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




    Download 3,3 Mb.