Friends:

I have a query similar in structure to the following:

SELECT
    T1.IBMREQD
FROM
    SYSIBM.SYSDUMMY1 T1
LEFT JOIN
    TABLE
    (
    SELECT
        IBMREQD
    FROM
        TABLE
        (
        SELECT
            IBMREQD
        FROM
            SYSIBM.SYSDUMMY1 T2
        WHERE
            T2.IBMREQD = T1.IBMREQD
        ) AS T3
    )AS T4
ON
    T4.IBMREQD = T1.IBMREQD

The LOJ query works fine, but if I change it to FULL OUTER JOIN (or
RIGHT JOIN), I get SQL0206N  "T1.IBMREQD" is not valid in the context
where it is used. It appears that T1 is no longer visible to the T3
query.

How can I get it to be?

(DB2 UDB LUW 8.2.3)

Thanks all,

--Jeff