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.
На этой странице сайта вы можете посмотреть видео онлайн SQL Type of Joins: длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь b2aLearning 07 Июль 2019, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 200 раз и оно понравилось 6 зрителям. Приятного просмотра!
