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.