[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
[OT] SQL question
- To: ukha_d@xxxxxxx
- Subject: [OT] SQL question
- From: "Dr John Tankard" <john@xxxxxxx>
- Date: Fri, 22 Mar 2002 17:39:19 +0000
- Delivered-to: mailing list ukha_d@xxxxxxx
- Mailing-list: list ukha_d@xxxxxxx; contact
ukha_d-owner@xxxxxxx
- Reply-to: ukha_d@xxxxxxx
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
Home |
Main Index |
Thread Index
|