Hi Cetin

>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

The original returned only one record between all parent so I added the GROUP BY, thus getting one for each parent, did I mess up somewhere? I'll try them both again.