>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.

In pseudocode it's like :

Select distinct values
while selecting
select the record with the latest date and populate related fields from that record

>> WHERE sNonCummu.dDueDt =
>> (SELECT MAX(sNC.dDueDt)
>> FROM sNonCummu sNC where sNonCummu.iPID = sNC.iPID )

Tells to find latest date for 'current of' iPID.
= works as subquery returns a single value.

Cetin