[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
RE: [OT] SQL question
- To: <ukha_d@xxxxxxx>
- Subject: RE: [OT] SQL question
- From: "Mark Hetherington" <mark.egroups@xxxxxxx>
- Date: Fri, 22 Mar 2002 18:18:27 -0000
- Delivered-to: mailing list ukha_d@xxxxxxx
- Mailing-list: list ukha_d@xxxxxxx; contact
ukha_d-owner@xxxxxxx
- Reply-to: ukha_d@xxxxxxx
How about using ORDER BY time/date/recordnumber, whatever can be used as a
distinct incrementing identifier for the child?
Mark.
> -----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
>
> John
>
>
>
>
> For more information: http://www.automatedhome.co.uk
> Post message: ukha_d@xxxxxxx
> Subscribe: ukha_d-subscribe@xxxxxxx
> Unsubscribe: ukha_d-unsubscribe@xxxxxxx
> List owner: ukha_d-owner@xxxxxxx
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
Home |
Main Index |
Thread Index
|