SQL : Types of Join

SQL : Types of Join in SQL

Here in this article i have covered all type of Joins available in SQL or SQL Server .

I have created two table as shown below :

Mainly there are 4 type of Joins frequently used as follow :

• Left Join

• Right Join

• Inner Join

• Full Join

[ 1 ] Left Join 

• Select rows from the left table with the matching rows in the right table. The result is NULL in the right side table columns when there is no match.

SELECT A.EmployeeID, A.Empnm, B.Name
FROM Emp_Detail AS A
left JOIN Dept_Detail AS B ON B.DepartmentID = A.DepartmentID

Output :

[ 2 ] Right Join

• Select rows from the right table  with the matching rows in the left table. The result is NULL in the left side table columns when there is no match.

SELECT A.EmployeeID, A.Empnm, B.Name
FROM Emp_Detail AS A
right JOIN Dept_Detail AS B ON B.DepartmentID = A.DepartmentID

Output:

[ 3 ] Inner Join

• Selects rows from two tables such that the value in one column of the first table also appears in a certain column of the second table.

SELECT A.EmployeeID, A.Empnm, B.Name
FROM Emp_Detail AS A
inner JOIN Dept_Detail AS B ON B.DepartmentID = A.DepartmentID

Output :

[ 4 ] Full Join

• Select all rows from the right table (A) and left table (B). The result is NULL in the left table(A)  and right table(B) columns when there is no match.

SELECT A.EmployeeID, A.Empnm, B.Name
FROM Emp_Detail AS A
FULL JOIN Dept_Detail AS B ON B.DepartmentID = A.DepartmentID

Output :

Whatsapp Messages, Whatsapp Images, Whatsapp Status, Whatsapp DP, Good morning images, Good morning ganesha, whatsapp ganesha, good morning shiva, whatsapp shiva, jai shri krishna, whatsapp krishna, Jai shri ram, Jai hanuman images, jai mata di, motivational messages, whatsapp motivational images, whatsapp funny messages, bajarangbali images, saibaba images, moraribapu images, moraribapu quotes, Guajarati images, Hindi images, gujarati messages, hindi messages, ganesh chaturthi images, vinayak chaturthi images, ramnavami images, navratri images, raksha bandhan images, friendship day images, independence day images, republic day images, Indian national flag, happy makar sankranti images, uttarayan messages, Happy Holi Images, Valentine Day images, Diwali wishes, Happy Dipavali Images, Happy Dhanteras Images, happy janmashtami images, jalarambapa images, Happy Sunday Images, Happy Thursday Images, Happy Saturday Images,

SQL : Format DateTime, MyCodeplex: SQL : Format DateTime, MyCodeplex , SQL , MYSQL , ASP.NET , What is MVC , Joins in SQL , Types of JOIN , C# , .NET Core , AngularJS , Sql Server , SQL SERVER 2008 Joins