INNER JOIN returns duplicate rows.

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Post Reply
Kapil Sharma
Registered Member
Posts: 52
Joined: Sun Sep 29, 2013 1:46 am
Location: India

INNER JOIN returns duplicate rows.

Post by Kapil Sharma »

Hi,

Can an INNER JOIN query retain back duplicate rows? I was expecting that it will return only the common rows in the DB2 tables but I am getting it. Can anyone tell why would it happen?
Thanks,
Kapil
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”