DB2 Version 4.1
Outer join with more than 2 tables


The nested table (correlation name C) consists of rows from DEPT paired with rows from EMP and, for each unpaired row of DEPT, the concatenation of that row with the null row of EMP and, for each unpaired row of EMP, the concatenation of that row with the null row of DEPT.

The final result consists of rows from C paired with rows from EMPPROJACT and, for each unpaired row of C, the concatenation of that row with the null row of EMPPROJACT and, for each unpaired row of EMPPROJACT, the concatenation of that row with the null row of C.

©Copyright 1996 Chuck Anesi all rights reserved