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.
En esta página del sitio puede ver el video en línea SQL Type of Joins: de Duración hora minuto segunda en buena calidad , que subió el usuario b2aLearning 07 julio 2019, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 200 veces y le gustó 6 a los espectadores. Disfruta viendo!
