Equi join is a special type of join in which we use only
equality operator. Hence, when you make a query for join using equality
operator then that join query comes under Equi join.
ProductName AS [Product Name]
,UnitPrice AS [Price]
AS [Product Category],ImagePath
FROM Products P
JOIN Categories C ON P.CategoryID=C.CategoryID
--Note:Using Clause is not supported by SQL Server
Inner join can have equality (=) and other operators (like
<,>,<>) in the join condition.
- Equi join only have equality (=) operator in the join
- Equi join can be an Inner join, Left Outer join, Right Outer
- The USING clause is not supported by SQL Server .
Natural join is a type of equi join which occurs implicitly
by comparing all the same names columns in both tables. The join result have
only one column for each pair of equally named columns.
Natural Join Example
SELECT * FROM Products
NATURAL JOIN Categories
Note : not supported
by sql server ,error message from sql server
“Incorrect syntax near ‘Categories’.