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



What is the differecne between equi-join and inner-join and natural join..Is there any difference ..

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

What is the differecne between equi-join and inner-join and natural join..Is there any difference ..

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

What is the differecne between equi-join and inner-join and natural join..Is there any difference ..

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

What is the differecne between equi-join and inner-join and natural join..Is there any difference ..

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

What is the differecne between equi-join and inner-join and natural join..Is there any difference ..

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

What is the differecne between equi-join and inner-join and natural join..Is there any difference ..

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

What is the differecne between equi-join and inner-join and natural join..Is there any difference ..

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

What is the differecne between equi-join and inner-join and natural join..Is there any difference ..

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

Post New Answer

More SQL Server Interview Questions

How to delete existing rows in a table?

0 Answers  


Can an automatic recovery be initiated by a user?

0 Answers  


What is the default Port No on which SQL Server listens?

0 Answers  


Which command is used for user defined error messages?

0 Answers  


Why do we use non clustered index?

0 Answers  






As per your opinion what are the five top responsibilities of a dba? : sql server database administration

0 Answers  


What is inline variable assignment?

0 Answers  


Can sql servers linked to other servers?

0 Answers  


Explain what is meant by replication of database?

0 Answers   Cap Gemini,


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,


What is the purpose of self join?

0 Answers  


What are the database roles? : sql server security

0 Answers  


Categories