• So‘rov : SELECT column_names [,... n] Table_1 FULL JOIN Table_2 ON condition 8.4 – rasm. Full outer join
  • ON auth_users1.username =auth_users2.username; Natija: 2. LEFT JOIN operatori So‘rov: SELECT * FROM auth_users1
  • So`rov: SELECT *FROM auth_users1 RIGHT JOIN auth_usres2 ON auth_users1.password = auth_users2.password Natija
  • FULL OUTER JOIN auth_users2 ON auth_users1.username =auth_users2.username; Natija
    		•

    Table_1 CROSS JOIN Table_2




    Download 1.63 Mb.
    bet6/9
    Sana19.11.2023
    Hajmi1.63 Mb.
    #101516
    1   2   3   4   5   6   7   8   9
    Bog'liq
    database
    Rux
    Table_1 CROSS JOIN Table_2





    1. SQLFULL 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:




    So‘rov : SELECT column_names [,... n]
    Table_1 FULL JOIN Table_2
    ON condition


    8.4 – rasm. Full outer join operatorining Venn diagrammasi orqali ko’rinishi



    Ishni bajarish tartibi

    1. SQL INNER JOIN operatori

    So‘rov: SELECT *FROM auth_users1
    INNER JOIN auth_users2
    ON auth_users1.username =auth_users2.username;
    Natija:



    2. LEFT JOIN operatori
    So‘rov: SELECT * FROM auth_users1
    LEFT JOIN auth_users2
    ON auth_users1.id =auth_users2.id;
    Natija:




    1. RIGHT JOIN operatori

    So`rov: SELECT *FROM auth_users1
    RIGHT JOIN auth_usres2
    ON auth_users1.password = auth_users2.password
    Natija:

    3. CROSS JOIN operatori
    So`rov:
    Natija:


    4. FULL OUTER JOIN operatori:
    So‘rov: SELECT *FROM auth_users1
    FULL OUTER JOIN auth_users2
    ON auth_users1.username =auth_users2.username;
    Natija:



    9-Amaliy ishi. Standart funksiyalardan foydalanib so‘rovlar yaratish



    Download 1.63 Mb.
    1   2   3   4   5   6   7   8   9




    Download 1.63 Mb.