[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
[OT] SQL question
- To: <ukha_d@xxxxxxx>
- Subject: [OT] SQL question
- From: "James Hoye" <james.hoye@xxxxxxx>
- Date: Wed, 11 Jul 2001 11:19:04 +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
Sorry for asking something completely non-HA, but I know you're such a
knowledgeable bunch...
I have 2 tables, A and B where A has a one-many relationship with B
How can I select from table A and only return the FIRST joined record from
B.
Table A:
ID CompanyName
=================
1 Acme Corp
2 Microshag
Table B:
CompanyID EmployeeName
========================
1 Bloggs
1 Jones
1 Smith
2 Gates
2 Williams
I need the SQL statement (if one exists) that will produce:
CompanyName EmployeeName
========================
Acme Corp Bloggs
Microshag Gates
I'll be using Access2000/JET4
Sorry for all those non-SQL bods...
James H
____________________________________
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
|