Error en sintaxis de query. Raro??

danytorres · #1 28-10-2005

Amigos, estoy realizando un query y mi BD es paradox el contenido es el siguiente:

Code:
---------------------------------------------------------------------

Código SQL [-]Select REMHIS.CODEMP, REMHIS.FECHIS, REMHIS.ZZ02 AS SSEMAN, REMHIS.ZZ05 AS HED, REMHIS.ZZ06 AS HEN, REMHIS.ZZ07 AS HENA,
   REMHIS.ZZ08 AS HEDF,  REMHIS.ZZ09 AS HENF,  REMHIS.ZZ10 AS HESAB, REMHIS.ZZ15 AS DIADESC,   REMHIS.ZZ04 AS DIFJNOCT,  
   REMHIS.ZZ13 AS BM,  REMHIS.ZZ14 AS BN,  REMHIS.ZZ12 AS REPOSOMEDICO,  REMHIS.ZZ78 AS PERACORD, REMHIS.ZZ81 AS PERSINDICAL,  
   REMHIS.ZZ24 AS OTRAASIG, REMHIS.ZZ11 AS PERREMUN,  REMHIS.ZZ16 AS RETROACTIVO,  REMMAE.Z050 AS  SUELDODIARIO, REMMAE.NOMBRE
 From  REMHIS, REMMAE
 Where    (Fechis >=:fini  and Fechis <=:ffin) and  (REMHIS.CODEMP =REMMAE.CODEMP) and (ACTIVO = 1)
 group by   REMHIS.CODEMP, REMHIS.FECHIS,   REMHIS.ZZ02,  REMHIS.ZZ05, REMHIS.ZZ06,  REMHIS.ZZ07,  REMHIS.ZZ08,  REMHIS.ZZ09, 
 REMHIS.ZZ10, REMHIS.ZZ15,   REMHIS.ZZ04,  REMHIS.ZZ13,  REMHIS.ZZ14, REMHIS.ZZ12,  REMHIS.ZZ78, REMHIS.ZZ81,  REMHIS.ZZ24,  
   REMHIS.ZZ11,REMHIS.ZZ16,  REMMAE.Z050, NOMBRE

________________________________________________________________

Cuando quiero activar el query de da este error: GROUP BY contains too many columns

Porque y como lo resuelvo?? Gracias