Outer Join

In the case of Outer Join, SQL Server returns all the data from at least one table and matching records from the another table based on the column being used in Join condition.

We have below type of Outer Join :-

• Left Outer Join
• Right Outer Join
• Full Outer Join