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

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Post Reply
rokishU
New Member
Posts: 4
Joined: Tue Sep 16, 2014 12:22 pm

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

Post 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?
zprogrammer
Global Moderator
Global Moderator
Posts: 588
Joined: Wed Nov 20, 2013 11:53 am
Location: Mars

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

Post by zprogrammer »

Innerjoin ,selfjoin and equi join are all same
zprogrammer
rokishU
New Member
Posts: 4
Joined: Tue Sep 16, 2014 12:22 pm

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

Post by rokishU »

What is equ?
zprogrammer
Global Moderator
Global Moderator
Posts: 588
Joined: Wed Nov 20, 2013 11:53 am
Location: Mars

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

Post by zprogrammer »

Corrected the typo it is equi join
zprogrammer
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “IBM DB2 and IMS DB/DC”