>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) >>
>SQL: GROUP BY clause is missing or invalid >>