[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
RE: Re: [OT] SQL question
- To: <ukha_d@xxxxxxx>
- Subject: RE: Re: [OT] SQL question
- From: "James Hoye" <james.hoye@xxxxxxx>
- Date: Wed, 11 Jul 2001 11:56:10 +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
> SELECT [Table A].[Company Name], First([Table B].EmployeeName) AS
> FirstOfEmployeeName
> FROM [Table A] INNER JOIN [Table B] ON [Table A].ID = [Table
> B].[Company ID]
> GROUP BY [Table A].[Company Name];
Taking the example one step further, is it possible t concatenate all of
the 'many' records ont the one row with a separator?
CompanyName EmployeeName
========================
Acme Corp Bloggs, Jones, Smith
Microshag Gates, Williams
Can you see what I'm getting at? We are trying to use hierarchical
recordsets, and are finding they are quite slow....
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
|