Funky GROUP BY

[Ruslan Zasukhin]

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

> Almost there...
> 
> SELECT Race.SeatNumber, Race.OfficeID, Candidate.CandidateID AS 'CCID',
> Results.CandidateID, Race.RaceCountyID, Results.RaceCountyID,
> Race.Meta_State, Sum(Results.VoteCount)
> 
> FROM    Results, Candidate, Race
> 
> WHERE Results.CandidateID = Candidate.CandidateID AND Race.RaceCountyID =
> Results.RaceCountyID AND Race.Meta_State='CA' AND Race.OfficeID = 'H'
> 
> GROUP BY Race.SeatNumber, Race.OfficeID, CCID, Results.CandidateID,
> Race.RaceCountyID, Results.RaceCountyID, Race.Meta_State, Results.VoteCount
> 
> ORDER BY Race.Seatnumber, Results.VoteCount DESC
> 
> When I reference the alias CCID in the GROUP BY clause, the error is:
> 
> -----
> 13:37:30: Error: Kernel error: 0x51500
> 13:37:30: Error: Identifier "CCID" is not found.
> -----
> 
> So it looks like the alias creation is OK not throwing an error, but the
> referencing of it is throwing an error.

Ivan will check now and will give answer.

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