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

Thierry,

Not sure if its just a typo in your post or not, but you have DTOCdatemaj instead of DTOC(datemaj). Also, you might get a better result using DTOS(datemaj).

Regards,