Inner Join
The "traditional" way for coding an inner join (or "natural join" or "equi-join"):
The result contains only rows paired by the join condition A.DEPTNO = B.WORKDEPT.
Inner joins may still be coded in the "traditional" way under DB2 V4.1. However, the new join syntax used for outer joins may also be used for inner joins. Example:
The WHERE clause is not required, and is shown here only to illustrate that one can include other predicates in addition to the join condition.
©Copyright 1996 Chuck Anesi all rights reserved