The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[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

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.