What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?
Answers were Sorted based on User's Feedback
Answer / sobia g.
An inner join is a join with a join condition that may contain both equality or non-equality sign whereas an equijoin is a join with a join condition that only contain only equality sign.
So we can say an equijoin is a type of inner join containing (Equal)= operator in the join condition.
It is good to know the difference between join and INNER JOIN keywoed. Actually there is no difference. If we write JOIN then by default INNER JOIN is performed. In the example it is also shown.
The following example will make you more clear.
In this example I used data as in example of Difference between Inner join and Outer join
SQL> select s.name,d.deptname from dept d, student s where d.deptid=s.deptid;
NAME DEPTNAME
--------------- ----------
Rafi CSE
Arju CSE
This example represents both INNER join and equijoin.
SQL> select s.name,d.deptname from dept d INNER JOIN student s on d.deptid=s.deptid;
NAME DEPTNAME
--------------- ----------
Rafi CSE
Arju CSE
Above example also represents both INNER join and equijoin.
SQL> select s.name,d.deptname from dept d INNER JOIN student s on d.deptid<>s.deptid;
NAME DEPTNAME
--------------- ----------
Rafi EEE
Raju EEE
Arju EEE
Raju CSE
Above example represents an inner join but not a equijoin.
SQL> select s.name,d.deptname from dept d JOIN student s on d.deptid<>s.deptid;
NAME DEPTNAME
--------------- ----------
Rafi EEE
Raju EEE
Arju EEE
Raju CSE
Above example show JOIN and INNER join keyword is same. If we don't specify INNER then by default inner join is performed.
Is This Answer Correct ? | 52 Yes | 11 No |
Answer / aditya shukla
Inner join-returns only matching row with equality or nonequality sign
equijoin-this also return matching row but only equal sign
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / sandy
Inner join can have equality (=) and other operators (like <,>,<>) in the join condition.
Equi join only have equality (=) operator in the join condition.
Equi join can be an Inner join, Left Outer join, Right Outer join
The USING clause is not supported by SQL Server and Sybase. This clause is supported by Oracle and MySQL.
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / jitendra mali
The equi join is retrived selected column from the both
the table
or
The inner join is only retrived selected column from the table
Is This Answer Correct ? | 6 Yes | 15 No |
Answer / ankita pandey
Equi Join -- Join performed in two tables having a common columna
with shared values in two tables by applying a where condition.
inner Join- Join performed in the same table itself(self join).
Is This Answer Correct ? | 3 Yes | 19 No |
Answer / monal
INNER JOIN and EQUI-JOIN are same. Not sure about Natural
Join. Found answer in Books On Line.
Is This Answer Correct ? | 29 Yes | 51 No |
Answer / samba shiva reddy . m
all are same but we can't use equi join and natural join in synax those are older
Is This Answer Correct ? | 7 Yes | 29 No |
Answer / mobin sathupally
All are same.
Eg:
SELECT
*
FROM Emp INNER JOIN Emp1
ON eid=id
SELECT
*
FROM Emp EQUI JOIN Emp1
ON eid=id
SELECT
*
FROM Emp NATURAL JOIN Emp1
ON eid=id
Is This Answer Correct ? | 18 Yes | 71 No |
How To delete duplicate record from a particular table?
Does hive support indexing?
Does the unique constraint create an index?
Describe in brief databases and sql server databases architecture.
Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer
When do you think a developer should use sql server-based cursors?
if no size is defined while creating the database, what size will the database have? : Sql server administration
How to convert numeric expression data types by assignment operations?
what are file groups?
How exceptions can be handled in sql server programming?
How do I run sql server 2014?
Explain log shipping?