Hi
Also this works!

select a.id,a.docno,a.docdt,;
  b.id as childid, b.duedt, b.amount ;
  from SAMPLE_parent a left join sample_child b on a.id = b.parentid ;
  where b.id = ;
  (select MAX(id) from sample_child c where c.parentid = b.parentid)

The results are the same as from backend.
Interesting.

>For VFP native coders I think this would make it a valid SQL for VFP too :
>

>select a.id,a.docno,a.docdt,;
>  b.id as childid, b.duedt, b.amount ;
>  from parent a left join child b on a.id = b.parentid ;
>  where b.DueDt = ;
>  (select MAX(DueDt) from child c where c.parentid = b.parentid)
>

>PS: Used DueDt instead of id just thinking they might be entered out of order.
>Cetin
>
>
>>If the backend is Firebird, the following SQL is valid:
>>

>>select a.id,a.docno,a.docdt,b.id as childid, b.duedt, b.amount from parent a left join child b
>>on a.id = b.parentid where b.id = (select MAX(id) from sample_child where parentid = a.id)
>>

>>If is VFP, I think that this will be available in VFP9 ("Queries of this type not supported" error message)
>>
>>
>>
>>>Hi all
>>>
>>>I have a parent-child like the following. It is a simple representation of the actual.
>>>
>>>---Parent
>>>ID 5
>>>Docno 123
>>>Docdt 12/12/03
>>>
>>>---Child 1
>>>ID 456
>>>ParentID 5
>>>DueDt 31/01/04
>>>Amount 75,000
>>>
>>>---Child 2
>>>ID 489
>>>ParentID 5
>>>DueDt 30/04/04
>>>Amount 50,000
>>>
>>>
>>>How to write the SQL to return. I don't want the older child records for the parent
>>>
>>>ID 5
>>>Docno 123
>>>Docdt 12/12/03
>>>ChildID 489
>>>DueDt 30/04/04
>>>Amount 50,000
>>>
>>>
>>>Please advise.