SQL Type of Joins:
SQL Type of Joins: #Inner Join #Left/Right Join #Outer Join
In this video, we have discussed on the various types of joins.
Join is a clause which is used to combine records of two tables, based on a column that relates both the table.
Inner Join: The result of this type of join is as per the common/matching records from both the tables based on a field/ column that defines the relation between both the tables.
Left /Left Outer Join: Here all the records of left table will be returned along-with the matching records from another table. In case, records are not matched from another table, the fields of another table in the resultset will be 'null'.
Right/Right Outer Join: Here all the records of right table will be returned along-with the matching records from another table. In case, records are not matched from another table, the fields of another table in the resultset will be 'null'.
Full Outer Join: Here all the records will be returned. Its a combination of Left join and right join resultset minus inner join resultset.
Note: Null is undefined and doesnt have any value, thereby 2 nulls cant have same value.
Sur cette page du site, vous pouvez voir la vidéo en ligne SQL Type of Joins: durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur b2aLearning 07 juillet 2019, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 200 fois et il a aimé 6 téléspectateurs. Bon visionnage!
