The UNION does implicit DISTINCT on the resultset and DISTINCT is illegal for memo/general fields. You may want to use UNION ALL instead. See SET ENGINEBEHAVIOR Command for more info.
Also, in UNION query before VFP9 you can only specify fields by position not by name and expressions are not allowed in any VFP version.
>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
>
--sb--