JOINs in DB2, need help.

[Manju Mainframe]

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.

[nicc]

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.

[zprogrammer]

Check the below diagram , I have tried to explain join in very quick way hope this is clear

JOINS.jpg

[Manju Mainframe]

Check the below diagram , I have tried to explain join in very quick way hope this is clear

JOINS.jpg

Thanks a lot for the diagram Pandora-Box.

[Chandan Yadav]

Try out some examples execution in Spufi or QMF you will get better understanding

[Manju Mainframe]

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?

[enrico-sorichetti]

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 

[Chandan Yadav]

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

[Manju Mainframe]

I'm in to support project for some time where SPUFI and QMF use is restricted.

[Robert Sample]

I'm in to support project for some time where SPUFI and QMF use is restricted.

Why not download and install the free DB2 system for Windows onto your personal machine?

[nicc]

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.

[Manju Mainframe]

Why not download and install the free DB2 system for Windows onto your personal machine?

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.

Thanks for the suggestion I did not think about these. Will try them. Thanks !