Page 1 of 1

In DB2, is there a difference between inner join and self join?

Posted: Wed Dec 23, 2015 1:59 pm
by rokishU
Hi,

What is the difference between inner join and self join in DB2? They seem to behave very similar to the level that I think they are just same. Is not it?

Re: In DB2, is there a difference between inner join and self join?

Posted: Wed Dec 23, 2015 3:46 pm
by zprogrammer
Innerjoin ,selfjoin and equi join are all same

Re: In DB2, is there a difference between inner join and self join?

Posted: Mon Dec 28, 2015 11:53 am
by rokishU
What is equ?

Re: In DB2, is there a difference between inner join and self join?

Posted: Mon Dec 28, 2015 12:34 pm
by zprogrammer
Corrected the typo it is equi join