Re: QMQRY QQRYSRC issues group by and order by

These two lines alone are what's important to this problem
SELECT RPPRCL, RPYEAR, RPBTCH, RPNAME, RPREFA, RPCHCK, RPAPYR
...
GROUP BY RPPRCL
...

Once you do a GROUP BY then the fields in the select have to be one of
three things:
- a function (like SUM, AVG, MIN, MAX...)
- included in the group by.
- omitted from the SELECT.

In other words you have to do one of three things

I - Change your select to
SELECT RPPRCL, MIN(RPYEAR), MAX(RPBTCH), MAX(RPNAME), SUM(RPREFA),
AVG(RPCHCK), SUM(RPAPYR)
- - tossing in a variety of functions as an example

II - Change your group by to include these:
SELECT RPPRCL, RPYEAR, RPBTCH, RPNAME, RPREFA, RPCHCK, sum(RPAPYR)
GROUP BY RPPRCL, RPYEAR, RPBTCH, RPNAME, RPREFA, RPCHCK

III - Drop some fields from the SELECT
SELECT RPPRCL, sum(RPAPYR)
GROUP BY RPPRCL

Rob Berendt