What is Equi Join in SQL Server
Introduction:
In this article i will explain what is Equi Join in SQL Server.
Description:
In previous articles i explained what are joins, what is INNER JOIN in SQL Server, what is LEFT JOIN (or) LEFT OUTER JOIN in SQL Server, what is RIGHT JOIN (or) RIGHT OUTER JOIN, what is FULL JOIN or FULL OUTER JOIN, and what is CROSS JOIN in SQL Server. Now i will explain what is Equi Join in SQL Server.
EQUI JOIN:
One column of first table can be mapped with a column of another table, such thing is called Equi Join.
Syntax:
select *
from Employee, Department
where Employee.DepartmentID = Department.DepartmentID
(or)
select *
from Employee as E, Department as D
where E.DepartmentID = D.DepartmentID
Note:
Equi Join and Inner Join are also same. Only the syntax differs.
-
CreatedNov 18, 2013
-
UpdatedOct 03, 2020
-
Views1,953
Related Articles
Different types of variables in SQL Server
What is Cross Join in SQL Server
How delete record from parent table when there is Foreign Key relation in SQL Server
What is the differences between CHAR, NCHAR, VARCHAR and NVARCHAR in SQL Server?
How to add or remove a column from a table in SQL Server?
How to insert values into Identity Column in SQL Server?
How to get a fixed-length value in SQL Server?
What is Left Join (or) Left Outer Join in SQL Server?
How to get current week dates in SQL Server?
What are the different types of Date formats in SQL Server?