29/10/2021 21:55:09  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cfg_c_configuracion <br><b>METODO:</b> ConsultaCtasSpg <br><b>ERROR->:</b><br>Invalid query: ERROR:  syntax error at or near "ON"
LINE 35:       LEFT JOIN scg_cuentas scg ON ON spg.codemp=scg.codemp ...
                                            ^
Whole query: SELECT  spg.spg_cuenta, 		                 
                        (spg.denominacion) as denominacion,
						 spg.sc_cuenta, 
						 scg.denominacion AS scg_denominacion, 
						(spg.codestpro1) as codestpro1, 
						(spg.codestpro2) as codestpro2,  
						(spg.codestpro3) as codestpro3,  
						(spg.codestpro4) as codestpro4,  
						(spg.codestpro5) as codestpro5, 
						(spg.estcla) as estcla,
						(spg.estcla||'|'||spg.codestpro1||'|'||spg.codestpro2||'|'||spg.codestpro3||'|'||spg.codestpro4||'|'||spg.codestpro5) AS codestpro,
						(spg.spg_cuenta||'|'||spg.estcla||'|'||spg.codestpro1||'|'||spg.codestpro2||'|'||spg.codestpro3||'|'||spg.codestpro4||'|'||spg.codestpro5) AS codclave,
						
								(
									spg.estcla||'-'||
									substring(spg.codestpro1,(26-4))||'-'||
									substring(spg.codestpro2,(26-2))||'-'||
									substring(spg.codestpro3,(26-2))
								) AS estructura,
								spg_ep3.denestpro3 AS denestpro
						  
				   FROM spg_cuentas spg
				  INNER JOIN spg_ep3 ON spg.codemp=spg_ep3.codemp  				
									AND spg.estcla=spg_ep3.estcla
									AND spg.codestpro1=spg_ep3.codestpro1  
									AND spg.codestpro2=spg_ep3.codestpro2  
									AND spg.codestpro3=spg_ep3.codestpro3
				  INNER JOIN spg_ep5 ON spg.codemp=spg_ep5.codemp  
								    AND spg.estcla=spg_ep5.estcla  
								    AND spg.codestpro1=spg_ep5.codestpro1  
								    AND spg.codestpro2=spg_ep5.codestpro2  
								    AND spg.codestpro3=spg_ep5.codestpro3  
								    AND spg.codestpro4=spg_ep5.codestpro4  
								    AND spg.codestpro5=spg_ep5.codestpro5
				  LEFT JOIN scg_cuentas scg ON ON spg.codemp=scg.codemp  				
									       AND spg.sc_cuenta=scg.sc_cuenta
				  WHERE spg.codemp='0001'  
				    AND spg.status = 'C' 	
					
				  ORDER BY spg.spg_cuenta,spg.estcla,spg.codestpro1,spg.codestpro2,spg.codestpro3,spg.codestpro4,spg.codestpro5