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