[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:46:40 +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
> I actually get to answer something on this group, Hooray!
>
> 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];
This group never ceases t amaze me. Thanks again Mark P. - just what I
needed.
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
|