06/03/2019 15:19:25  *****  ERROR DE SISTEMA:   *****  rhernandez  *****  CLASE->Report MÉTODO->uf_retencionarc_personal ERROR->Invalid query: ERROR:  la columna «sno_personal.coreleper» debe aparecer en la cláusula GROUP BY o ser usada en una función de agregación
LINE 1: ...cedper, sno_personal.nomper, sno_personal.apeper, sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.coreleper   FROM sno_personal, sno_personalisr, sno_hpersonalnomina, sno_hperiodo  WHERE sno_personal.codemp = '0001'    AND sno_hperiodo.anocur = '2018'    AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),1,4) = '2018'     AND ( sno_hpersonalnomina.codnom='1003'  ) AND sno_personal.codper BETWEEN '0017490203' AND '0017490203'    AND sno_hpersonalnomina.codemp = sno_hperiodo.codemp    AND sno_hpersonalnomina.codnom = sno_hperiodo.codnom    AND sno_hpersonalnomina.anocur = sno_hperiodo.anocur    AND sno_hpersonalnomina.codperi = sno_hperiodo.codperi    AND sno_personal.codemp = sno_personalisr.codemp    AND sno_personal.codper = sno_personalisr.codper    AND sno_personal.codemp = sno_hpersonalnomina.codemp    AND sno_personal.codper = sno_hpersonalnomina.codper  GROUP BY sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper ORDER BY sno_personal.codper 

06/03/2019 15:19:35  *****  ERROR DE SISTEMA:   *****  rhernandez  *****  CLASE->Report MÉTODO->uf_retencionarc_personal ERROR->Invalid query: ERROR:  la columna «sno_personal.coreleper» debe aparecer en la cláusula GROUP BY o ser usada en una función de agregación
LINE 1: ...cedper, sno_personal.nomper, sno_personal.apeper, sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.coreleper   FROM sno_personal, sno_personalisr, sno_hpersonalnomina, sno_hperiodo  WHERE sno_personal.codemp = '0001'    AND sno_hperiodo.anocur = '2018'    AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),1,4) = '2018'     AND ( sno_hpersonalnomina.codnom='1003'  ) AND sno_personal.codper BETWEEN '0017490203' AND '0017490203'    AND sno_hpersonalnomina.codemp = sno_hperiodo.codemp    AND sno_hpersonalnomina.codnom = sno_hperiodo.codnom    AND sno_hpersonalnomina.anocur = sno_hperiodo.anocur    AND sno_hpersonalnomina.codperi = sno_hperiodo.codperi    AND sno_personal.codemp = sno_personalisr.codemp    AND sno_personal.codper = sno_personalisr.codper    AND sno_personal.codemp = sno_hpersonalnomina.codemp    AND sno_personal.codper = sno_hpersonalnomina.codper  GROUP BY sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper ORDER BY sno_personal.codper 

06/03/2019 15:19:47  *****  ERROR DE SISTEMA:   *****  rhernandez  *****  CLASE->Report MÉTODO->uf_retencionarc_personal ERROR->Invalid query: ERROR:  la columna «sno_personal.coreleper» debe aparecer en la cláusula GROUP BY o ser usada en una función de agregación
LINE 1: ...cedper, sno_personal.nomper, sno_personal.apeper, sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.coreleper   FROM sno_personal, sno_personalisr, sno_hpersonalnomina, sno_hperiodo  WHERE sno_personal.codemp = '0001'    AND sno_hperiodo.anocur = '2018'    AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),1,4) = '2018'     AND ( sno_hpersonalnomina.codnom='1003'  ) AND sno_personal.codper BETWEEN '0017490203' AND '0017490203'    AND sno_hpersonalnomina.codemp = sno_hperiodo.codemp    AND sno_hpersonalnomina.codnom = sno_hperiodo.codnom    AND sno_hpersonalnomina.anocur = sno_hperiodo.anocur    AND sno_hpersonalnomina.codperi = sno_hperiodo.codperi    AND sno_personal.codemp = sno_personalisr.codemp    AND sno_personal.codper = sno_personalisr.codper    AND sno_personal.codemp = sno_hpersonalnomina.codemp    AND sno_personal.codper = sno_hpersonalnomina.codper  GROUP BY sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper ORDER BY sno_personal.codper 

06/03/2019 15:20:05  *****  ERROR DE SISTEMA:   *****  rhernandez  *****  CLASE->Report MÉTODO->uf_retencionarc_personal ERROR->Invalid query: ERROR:  la columna «sno_personal.coreleper» debe aparecer en la cláusula GROUP BY o ser usada en una función de agregación
LINE 1: ...cedper, sno_personal.nomper, sno_personal.apeper, sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.coreleper   FROM sno_personal, sno_personalisr, sno_hpersonalnomina, sno_hperiodo  WHERE sno_personal.codemp = '0001'    AND sno_hperiodo.anocur = '2018'    AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),1,4) = '2018'     AND ( sno_hpersonalnomina.codnom='1003'  ) AND sno_personal.codper BETWEEN '0017490203' AND '0017490203'    AND sno_hpersonalnomina.codemp = sno_hperiodo.codemp    AND sno_hpersonalnomina.codnom = sno_hperiodo.codnom    AND sno_hpersonalnomina.anocur = sno_hperiodo.anocur    AND sno_hpersonalnomina.codperi = sno_hperiodo.codperi    AND sno_personal.codemp = sno_personalisr.codemp    AND sno_personal.codper = sno_personalisr.codper    AND sno_personal.codemp = sno_hpersonalnomina.codemp    AND sno_personal.codper = sno_hpersonalnomina.codper  GROUP BY sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper ORDER BY sno_personal.codper