The error is not for GROUP BY because you didn't have one but for ORDER BY :o)
Try to change it to:

....
ORDER BY 1,8
....


>can someone tell me why this SQL request doesn't work in VFP8 ??? I got an error on ther "GROUP BY" clause
>
>

>SELECT CODEMED,NOINTERNE,NAM,NOM,DATENAISS,CODEDIAG,HONOTOTAL,DATEMAJ;
>	from factcur;
>	WHERE ((FACTCUR.STATUSFACT = "F") .AND.;
>		  (AT("B",FACTCUR.CONSSPECIA)<>0) .AND.;
>		  !EMPTY(FACTCUR.DATEMAJ) .AND.;
>		  BETWEEN(FACTCUR.DATEMAJ,M_DATDEB,M_DATFIN)) .AND.;
>		  BETWEEN(FACTCUR.CODEMED, M_MEDDEB, M_MEDFIN);
>union ;
>select CODEMED,NOINTERNE,NAM,NOM,DATENAISS,CODEDIAG,HONOTOTAL,DATEMAJ;
>	from facthisto ;
>	WHERE ((FACTHISTO.STATUSFACT = "F") .AND.;
>		  (AT("B",FACTHISTO.CONSSPECIA)<>0) .AND.;
>		  !EMPTY(FACTHISTO.DATEMAJ) .AND.;
>		  BETWEEN(FACTHISTO.DATEMAJ,M_DATDEB,M_DATFIN)) .AND.;
>		  BETWEEN(FACTHISTO.CODEMED, M_MEDDEB, M_MEDFIN) ;
>order by codemed,DTOCdatemaj ;
>INTO CURSOR facttmp
>