I have a reporting object with a three table join. One of the table
SCB5201 has a CLOSDT(A date field with nulls allowed). The report is
showing the close date as NULL(even though some the dates are not NULL). The database is DB2. Given
below is the join.

JOIN AGENT.AGT_NUMBER IN AGENT TO ALL SCB5111.LPAGENTCODE IN SCB5111 AS J0
JOIN
SCB5111.BUSNID AND SCB5111.CUSTID IN AGENT TO ALL SCB5201.BUSNID
AND SCB5201.CUSTID IN SCB5201 AS J1
END

Any ideas?.

It's showing the CLOSDT as null for every row of your report?