SQL joins and unions

This tutorial describes two ways to combine data from different tables in an IBM DB2 database:

    * By joining the tables
    * By using the UNION, EXCEPT, and INTERSECT operators

The first part of this tutorial presents examples of inner and outer joins.

The second part illustrates how to combine data from different tables by using UNION, EXCEPT, and INTERSECT operators, which take the intermediate result set from one query expression and combine it with the result set from another query expression.

Click here for more...!