Types of JOINS Statement in SQL Server:
(1) “JOINS” is used to combine data from two or more tables, according to the related column similarity.
(2) Different types of JOINS are-
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
- SELF JOIN
(3) INNER JOIN: Return records having the same value in both tables.
(4) LEFT JOIN: Return all records from the left table, having matched records in the right table.
(5) Right JOIN: Return all records from the right table, having matched records in the left table.
(6) FULL JOIN: Return all records when there is a match in the left or right table.
(7) SELF JOIN: Join with the same table.
