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.
Auf dieser Seite können Sie das Online-Video SQL Type of Joins: mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer b2aLearning 07 Juli 2019 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 200 Mal angesehen und es wurde von 6 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
