Funky GROUP BY

[Ruslan Zasukhin]

On 10/11/06 7:05 PM, "Balestrieri, John" <jbalestrieri at ap.org> wrote:

Hi John,

> Hello, I have group by clause that's not working as expected when I run it
> from Valentina Studio 2.4.3:
> 
> SELECT Race.SeatNumber, Race.OfficeID, Race.Meta_State,
> Sum(Results.VoteCount)
> FROM Results, Race Group BY Race.SeatNumber
> 
> The error is:
> 
> ----
> 11:55:50: Error: Kernel error: 0x42508
> 11:55:50: Error: In the SELECT clause you can use only fields listed in the
> GROUP BY and aggregative functions.
> ----

Actually this is EXPECTED and CORRECT result according to SQL92.

    In the SELECT clause you can use only fields listed in the
    GROUP BY and aggregative functions.


Race.OfficeID -- is problem field in your query.

If you want have it in SELECT, you MUST include it into GROUP BY.



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]