What is Self Join in SQL ?
A self-join is a join in which a table is joined with itself, based on the related column is called a self join on SQL Server
Example : – Self Join Example
What is INNER JOIN in SQL?
Inner join returns only those records from the tables that match the specified condition
What is the Right JOIN in SQL?
The Right join is used to retrieve all rows from the right-hand table and only those rows from the other table that fulfilled the join condition.
What is Left Join in SQL?
The Left Join is used to fetch all rows from the left-hand table and common records between the specified tables. It returns all the rows from the left-hand side table even though there are no matches on the right-hand side table. If it will not find any matching record from the right side table, then it returns null. This join can also be called a Left Outer Join.