What are the types of Joins in SQL Server?

There are four types of joins in SQL Server:

Left outer join - A left join returns all the rows from the left table, along with any matching rows from the right table. 

Right outer join - A right join returns all the rows from the right table, along with any matching rows from the left table. 

Full outer join - A full outer join returns all the rows from both the left and right tables in the join.

Inner join - An inner join returns only the common rows from both tables that meet the join condition.

Post a Comment

Previous Post Next Post