Hi All:

The following works in VFP 7 but not in 8. What am I doing wrong?

cflcode = 'GEG12031'
SELE flckmast.fm_flcode, grower.gr_shdesc,  ;
	flckmast.fm_hatched, SUM(hatcinfo.hi_amt)  ;
	FROM grower ;
	inner JOIN flckmast ;
	ON grower.gr_grcode = flckmast.fm_grcode ;
	inner JOIN hatcinfo ;
	ON hatcinfo.hi_flcode = flckmast.fm_flcode ;
	WHERE !EMPTY(flckmast.fm_cycle)  ;
	AND flckmast.fm_flcode  = cflcode ;
	GROUP BY hatcinfo.hi_flcode  ;
	ORDER BY flckmast.fm_farmdlv ;
	INTO CURSOR "Z" + SUBSTR(SYS(2015) ,3,10)

The error message is:

SQL: GROUP BY clause is missing or invalid

Thanx -

Yossi