SQL Type of Joins: #Inner Join #Left/Right Join #Outer Join

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.