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.