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.
On this page of the site you can watch the video online SQL Type of Joins: with a duration of hours minute second in good quality, which was uploaded by the user b2aLearning 07 July 2019, share the link with friends and acquaintances, this video has already been watched 200 times on youtube and it was liked by 6 viewers. Enjoy your viewing!
