By using joins, you can retrieve data from two or more tables based on logical relationships between the tables. Joins indicate how Microsoft SQL Server should use data from one table to select the rows in another table.
Types of Join:
1. Inner join
2. Equi-join
3. Cross join
4. Outer joins
a. Leftouter join
b. Rightouter joins
c. Full outer join
5. Self-join
Leave Comment