>Hi Cetin and Dorin
>
>Thanks both of you. Here is the final code from your suggestions
>
>

SELECT tNonCummu.*, sNonCummu.*
>    FROM tNonCummu
>       JOIN sNonCummu ON tNonCummu.iID = sNonCummu.iPID
>    WHERE sNonCummu.dDueDt =
>       (SELECT MAX(sNC.dDueDt)
>          FROM tNonCummu tNC
>             JOIN sNonCummu sNC ON tNC.iID = sNC.iPID
>          GROUP BY sNC.iPID)

>
>We have to group or else only one is shown.

Bhavbuti,
You don't need to group by but be careful this is not the same with the one we suggested.

SELECT tNonCummu.*, sNonCummu.*
    FROM tNonCummu
       JOIN sNonCummu ON tNonCummu.iID = sNonCummu.iPID
    WHERE sNonCummu.dDueDt =
       (SELECT MAX(sNC.dDueDt)
          FROM sNonCummu sNC where sNonCummu.iPID = sNC.iPID )

Cetin