|
Re: Equi Join and Inner Join [message #133834 is a reply to message #133830] |
Mon, 22 August 2005 06:41 |
kiran
Messages: 503 Registered: July 2000
|
Senior Member |
|
|
Equi join is the join which contains an equal operator in its join condition.
where as Inner join is a join which returns rows from two or more tables which satisfies the join condition.
more options are here.
--Kiran.
|
|
|
Re: Equi Join and Inner Join [message #133843 is a reply to message #133834] |
Mon, 22 August 2005 07:05 |
dmitry.nikiforov
Messages: 723 Registered: March 2005
|
Senior Member |
|
|
Inner join is a subtype of Equijoin.
Equijoin means the join betreen tables where the values of
two or more columns are equal:
SQL> /* Inner join as equijoin */
SQL> select dept.deptno from dept join emp on emp.deptno = dept.deptno;
DEPTNO
----------
20
30
30
20
30
30
10
20
10
30
20
30
20
10
14 rows selected.
SQL> /* Natural join as equijoin */
SQL> select deptno from dept natural join emp;
DEPTNO
----------
20
30
30
20
30
30
10
20
10
30
20
30
20
10
14 rows selected.
Rgds.
|
|
|
|
Re: Equi Join and Inner Join [message #134223 is a reply to message #133843] |
Tue, 23 August 2005 23:12 |
nirmalnarayan
Messages: 261 Registered: April 2005 Location: India
|
Senior Member |
|
|
HI,
Thanks all. So, there will be nothing wrong in saying , that 'Equi join' and 'Inner Join' are different terminologies applied to same functionality, right ?
Thanks and Regards,
Nirmal
|
|
|
|
Re: Equi Join and Inner Join [message #134367 is a reply to message #133830] |
Wed, 24 August 2005 09:19 |
mchadder
Messages: 224 Registered: May 2005 Location: UK
|
Senior Member |
|
|
Hello.
Yeah, I would consider that incorrect too. An INNER JOIN is *some kind* of join between the two sets, whether equality or inequality, whereas an equi join is always equality, i.e.
here's an example of an INNER JOIN being a "non-equi join", whereas a NATURAL JOIN (etc. etc.) has to be an equi-join :
SQL> SELECT *
2 FROM dual
3 INNER JOIN dual d2 ON ( d2.dummy != dual.dummy );
no rows selected
SQL> SELECT *
2 FROM dual NATURAL JOIN dual d2;
D
-
X
Rgds
|
|
|
|
|
|
Re: Equi Join and Inner Join [message #550949 is a reply to message #550945] |
Fri, 13 April 2012 14:44 |
|
thiyagusham
Messages: 112 Registered: April 2012 Location: Chennai
|
Senior Member |
|
|
Hello to every one !
" No more difference between simple join and Inner join "
Simple joins some times called INNER JOIN.
Recently I saw this post. I visited some other blogs regarding inner joins and simple joins..
Inner join classified as
EQUI JOIN
NON Equi JOIN
'equi-join' means joining tables using the equality operator or equivalent.
I would still call an outer join an 'equi-join' if it only uses equality (others may disagree)
'NON Equi Join' always condition relates two tables by an operator other than equality
SQL>select a.name, a.empid, a.empid, from x a, y b
where a.empid=b.empid ;
NAME EMAIL EMPID
Sam sam@orcl.com 1060
Rose rose@orcl.com 1061
Chris chris@sap.com 1062
If any clarification please post valuable comments with clear
Explanation.
Thanks and Regards
Thiyagusham .G
|
|
|