[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: "Graham Howe" <graham@xxxxxxx>
- Date: Wed, 11 Jul 2001 11:48:07 +0100
- Delivered-to: rich@xxxxxxx
- Delivered-to: mailing list ukha_d@xxxxxxx
- Mailing-list: list ukha_d@xxxxxxx; contact
ukha_d-owner@xxxxxxx
- Reply-to: ukha_d@xxxxxxx
Try this:
SELECT T1.CompanyName, MIN(T2.EmployeeName)
FROM A AS T1, B AS T2
WHERE T1.ID = T2.CompanyID
ORDER BY T2.EmployeeName
I will try this now t see that it works
Graham
____________________________________
Automated Home UK
http://www.automatedhome.co.uk
____________________________________
Your use of Yahoo! Groups is subject t http://docs.yahoo.com/info/terms/
Home |
Main Index |
Thread Index
|