There are three types of SQL Outer Joins, and they are:
- Right Outer Join: Also called as Right Join. It returns matching rows from the left table (if any), and all the rows present in the Right table.
- Left Outer join: Or simply called as Left Join. It returns all the rows present in the Left table and matching rows from the right table (if any).
- Full Outer Join: Also called as Full Join. It returns all the rows present in both the Left table, and right table.
In this article we will show you, How to write a SQL Query to Join two or more tables using the SQL Outer Joins with example. This is one of the SQL Server Frequently Asked Question. For this example, We are going to use the below shown data
Data present in the Department Table is:
SQL Outer Join Examples
Following are the list of SQL Outer Join example that will demonstrate each and every outer join.
SQL Right Outer Join Example
In this example we will show you, How to write Right Outer Join in SQL Server. For this, We are going to use the tables that we shown above. We had already explained the Right Outer Join in our previous article. So, I suggest you to refer the same for better understanding
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
--SQL OUTER JOIN :- Example for RIGHT OUTER JOIN USE [SQLTEST] GO SELECT Emp.[EmpID] ,Emp.[FirstName] ,Emp.[LastName] ,Emp.[Education] ,Emp.[YearlyIncome] ,Emp.[Sales] ,Dept.[DepartmentName] FROM [Employees] AS Emp RIGHT JOIN [Department] AS Dept --RIGHT OUTER JOIN [Department] AS Dept ON Emp.DeptID = Dept.DeptID |
OUTPUT
SQL Left Outer Join Example
This example show you, How to write Left Outer Join in SQL Server. We had already explained the Left Outer Join in our previous article. So, I suggest you to refer the same for better understanding
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
--SQL OUTER JOIN :- Example for LEFT OUTER JOIN USE [SQLTEST] GO SELECT Emp.[FirstName] AS [First Name] ,Emp.[LastName] AS [Last Name] ,Emp.[Education] ,Emp.[YearlyIncome] AS [Yearly Income] ,Emp.[Sales] ,Dept.[DepartmentName] AS [Department] FROM [Employees] AS Emp LEFT OUTER JOIN [Department] AS Dept ON Emp.DeptID = Dept.DeptID |
OUTPUT
SQL Full Outer Join Example
In this example we will show you, How to write a Full Outer Join in SQL Server. We had already explained the Full Outer Join in our previous article. So, I suggest you to refer them for better understanding
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
--SQL OUTER JOIN :- Example for FULL OUTER JOIN USE [SQLTEST] GO SELECT Emp.[FirstName] AS [First Name] ,Emp.[LastName] AS [Last Name] ,Emp.[Education] ,Emp.[YearlyIncome] AS [Yearly Income] ,Emp.[Sales] ,Dept.[DepartmentName] AS [Department] FROM [Employees] AS Emp FULL OUTER JOIN [Department] AS Dept ON Emp.DeptID = Dept.DeptID |
OUTPUT
Thank You for Visiting Our Blog
Share your Feedback, or Code!!