01/07/2020 22:14:16  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> consulta_sucursalInvalid query: ERROR:  column "s.codsuc" must appear in the GROUP BY clause or be used in an aggregate function
LINE 2:                  s.codsuc, 
                         ^
Whole query: SELECT  DISTINCT ON (s.codsuc) 
					            s.codsuc, 
								MAX(s.nomsuc) AS nomsuc, 
								MAX(s.sigsuc) AS sigsuc, 
								MAX(s.sucmatriz) AS sucmatriz, 
					            MAX(s.codseriesuc) AS codseriesuc, 
								MAX(s.nrocontinisuc) AS nrocontinisuc, 
                                MAX(s.coduniejesuc) AS coduniejesuc, 
								MAX(s.codalmsuc) AS codalmsuc, 
								MAX(s.enablescgunieje) AS enablescgunieje,								
								MAX(uad.coduniadm) AS coduniadm, 
								MAX(uad.codestpro1) AS codestpro1, 
								MAX(uad.codestpro2) AS codestpro2, 
								MAX(uad.codestpro3) AS codestpro3, 
								MAX(uad.codestpro4) AS codestpro4, 
                                MAX(uad.codestpro5) AS codestpro5, 
								MAX(uad.estcla) AS estcla,								
								'('||s.codsuc||')-'||MAX(s.sigsuc) as infosuc  FROM cxc_sucursales s   LEFT JOIN spg_dt_unidadadministrativa uad ON uad.coduniadm = s.coduniejesuc
					                                                            AND s.coduniejesuc NOT IN('','----------')	
					                   WHERE s.nomsuc ILIKE('%%') AND s.codsuc ILIKE('%%') ORDER BY s.codsuc