JOINs in DB2, need help.
-
- Registered Member
- Posts: 24
- Joined: Mon Aug 12, 2013 10:50 am
JOINs in DB2, need help.
Hi,
The concepts of joins are very confusing for me. I really do not undertand the difference between Inner Join and Outer Joins. I have been looking for some good example on inner join, left outer join, and right outer join but could not find something for mainframes.
Could someone provide me examples of the same? And if possible explain it.
The concepts of joins are very confusing for me. I really do not undertand the difference between Inner Join and Outer Joins. I have been looking for some good example on inner join, left outer join, and right outer join but could not find something for mainframes.
Could someone provide me examples of the same? And if possible explain it.
Re: JOINs in DB2, need help.
It is out there on the internet because I have seen it in one of the many tutorials but which one I cannot remember. I think you need one with a Venn diagram to explain it better.
Regards
Nic
Nic
-
- Global Moderator
- Posts: 588
- Joined: Wed Nov 20, 2013 11:53 am
- Location: Mars
Re: JOINs in DB2, need help.
Check the below diagram , I have tried to explain join in very quick way hope this is clear
You do not have the required permissions to view the files attached to this post.
zprogrammer
-
- Registered Member
- Posts: 24
- Joined: Mon Aug 12, 2013 10:50 am
Re: JOINs in DB2, need help.
Thanks a lot for the diagram Pandora-Box.Pandora-Box wrote:Check the below diagram , I have tried to explain join in very quick way hope this is clear
-
- Website Team
- Posts: 70
- Joined: Wed Jul 31, 2013 10:19 pm
Re: JOINs in DB2, need help.
Try out some examples execution in Spufi or QMF you will get better understanding
-
- Registered Member
- Posts: 24
- Joined: Mon Aug 12, 2013 10:50 am
Re: JOINs in DB2, need help.
Thanks Chandan. But I am not allowed to create some test data to test these things. With out test tables how can I do it?
-
- Global Moderator
- Posts: 826
- Joined: Wed Sep 11, 2013 3:57 pm
Re: JOINs in DB2, need help.
if You are a developer of You should have access to a DB2 instance
think about the tables You have access and if they share some columns You can try the joins on them
and remember to limit the result set
think about the tables You have access and if they share some columns You can try the joins on them
and remember to limit the result set
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
-
- Website Team
- Posts: 70
- Joined: Wed Jul 31, 2013 10:19 pm
Re: JOINs in DB2, need help.
You can have Db2 instance on local machine check for Db2 Express edition n test it out. Joins works same if you doing it on local machine or on mainframes.
As Enrico said if you are a developer you should have access
As Enrico said if you are a developer you should have access
-
- Registered Member
- Posts: 24
- Joined: Mon Aug 12, 2013 10:50 am
Re: JOINs in DB2, need help.
I'm in to support project for some time where SPUFI and QMF use is restricted.
- Robert Sample
- Global Moderator
- Posts: 1895
- Joined: Fri Jun 28, 2013 1:22 am
- Location: Dubuque Iowa
Re: JOINs in DB2, need help.
Why not download and install the free DB2 system for Windows onto your personal machine?I'm in to support project for some time where SPUFI and QMF use is restricted.
Re: JOINs in DB2, need help.
Or even download any old RDBMS that uses SQL and experiment with that. For the record I use SQLite and it gets me through all I need to know with standard SQL queries.
Regards
Nic
Nic
-
- Registered Member
- Posts: 24
- Joined: Mon Aug 12, 2013 10:50 am
Re: JOINs in DB2, need help.
Why not download and install the free DB2 system for Windows onto your personal machine?
Thanks for the suggestion I did not think about these. Will try them. Thanks !Or even download any old RDBMS that uses SQL and experiment with that. For the record I use SQLite and it gets me through all I need to know with standard SQL queries.
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