RE: [OT] SQL question

["Dr John Tankard" <john@xxxxxxx>]

> How about using ORDER BY time/date/recordnumber, whatever can
> be used as a distinct incrementing identifier for the child?
>
> Mark.

Thanks Mark

I have not quite got it

Say this is the child data

Parent Date       Comment
1      22/02/02   Some data
1      20/02/02   Some more data with the same parent
2      05/02/02   More data but for a different parent
2      01/02/02   More data for the second parent
3      20/02/02   Data for a third parent

The result set I am after is this
1      22/02/02   Some data
2      05/02/02   More data but for a different parent
3      20/02/02   Data for a third parent

IE the most receint comment only ?


John


>
> > -----Original Message-----
> > From: Dr John Tankard [mailto:john@xxxxxxx]
> > Sent: 22 March 2002 17:39
> > To: ukha_d@xxxxxxx
> > Subject: [ukha_d] [OT] SQL question
> >
> >
> > Sorry for the OT post
> >
> > drastically simplified
> > 2 tables
> > 1 to many relationship
> >
> > I want to select just the most recent child, so for each row in
the
> > parent I want to show only one (the most recent) row in the child
> >
> > DISTINCT wont work because the child rows are not identical
> >
> > Any Ideas
> >