Re: Re: [OT] SQL question

["Steve Cooper" <steve.cooper@xxxxxxx>]

If you are using things like MIN or FIRST make sure you use an ORDER BY
statement.  SQL does not guarantee the order that data is returned in if
you don't use one.

Example:  At work we have a SQL 7 database table that has a clustered index
on it and a Select * from TABLE1 returns the data in a different order
depending on whether the database is read-only or not.

Steve



"Mark Pollock"
<pollocmc@total        To:     ukha_d@xxxxxxx
ise.co.uk>             cc:
Subject:     [ukha_d] Re: [OT] SQL question
11/07/01 11:33
Please respond
to ukha_d






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];

Mark

--- In ukha_d@y..., "James Hoye" <james.hoye@s...> wrote:
> 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/








____________________________________
Automated Home UK
http://www.automatedhome.co.uk
____________________________________

Your use of Yahoo! Groups is subject t  http://docs.yahoo.com/info/terms/