SQL error returned in VStudio but not in V4Rb

[Balestrieri, John]

Hello, the following error is returned from VStudio 3.5.2 when I try to
execute the SQL attached to the bottom of this email:

Error: Kernel error: 0x42508. In the SELECT clause you can use only fields
listed in the GROUP BY and aggregative functions.

This SQL did not produce any errors in VStudio2 or V4Rb2 - versions 2
through 2.5 beta, in late 2006.

VStudio 3 is now balking on the command, while V4Rb version 3.5.2 still
executes it without error and returns a valid Vcursor with a found record
set.

Thanks,
John



The SQL statement:

SELECT
   Race.FIPSCode,
   Results.Party,
   Candidate.LastName,
   Candidate.FirstName,
   Candidate.MiddleName,
   Candidate.Junior,
   Candidate.UseJunior,
   Candidate.PoliticianID,
   Results.Incumbent,
   Results.Winner,
   Sum(Results.VoteCount) AS 'VoteTally',
   Sum(Race.PrecinctsReporting) AS 'PrecinctTally',
   Sum(Race.TotalPrecincts) AS 'PrecinctTotal'

FROM    
   Results,
   Candidate,
   Race
        
WHERE
   Results.CandidateID = Candidate.CandidateID
   AND Race.RaceCountyID = Results.RaceCountyID
   AND Results.Meta_State = 'AZ' --State postal
   AND Race.OfficeID = 'S' --Office
   AND Race.FIPSCode = 0
       
GROUP BY
   Race.FIPSCode,
   Results.Party,
   Candidate.LastName,
   Candidate.FirstName,
   Candidate.MiddleName,
   Candidate.Junior,
   Candidate.UseJunior,
   Candidate.PoliticianID,
   Results.Incumbent,
   Results.Winner
   
ORDER BY
   VoteTally DESC



The information contained in this communication is intended for the use
of the designated recipients named above. If the reader of this 
communication is not the intended recipient, you are hereby notified
that you have received this communication in error, and that any review,
dissemination, distribution or copying of this communication is strictly
prohibited. If you have received this communication in error, please 
notify The Associated Press immediately by telephone at +1-212-621-1898 
and delete this email. Thank you.
[IP_US_DISC]
msk dccc60c6d2c3a6438f0cf467d9a4938