[select s.sector,p.programa,sp.subprog,pr.proyecto,ac.actividad,s.denominacion as sdenominacion,p.denominacion as pdenominacion,sp.denominacion as spdenominacion,pr.denominacion as prdenominacion,ac.denominacion as acdenominacion ]+; [from ]+oApp.cDBO+[spg_sector s,]+oApp.cDBO+[spg_programa p,]+oApp.cDBO+[spg_subprograma sp,]+oApp.cDBO+[spg_proyecto pr,]+oApp.cDBO+[spg_actividad ac ]+; [where s.sector = p.sector and ]+; [p.sector = sp.sector and ]+; [p.programa = sp.programa and ]+; [sp.sector = pr.sector and ]+; [sp.programa = pr.programa and ]+; [sp.subprog = pr.subprog and ]+; [pr.sector = ac.sector and ]+; [pr.programa = ac.programa and ]+; [pr.subprog = ac.subprog and ]+; [pr.proyecto = ac.proyecto ]+; [order by ac.sector,ac.programa,ac.subprog,ac.proyecto,ac.actividad ] select * from spe_relacion_es as i,sfp_estpro1 as e1,sfp_estpro2 as e2,sfp_estpro3 as e3,sfp_estpro4 as e4,sfp_estpro5 as e5 where i.codestpro1=e1.codestpro1 and e1.codestpro1='00000000000000000000PROY1' and i.codestpro1=e2.codestpro1 and i.codestpro2=e2.codestpro2 and e2.codestpro1='00000000000000000000PROY1' and e2.codestpro2='0000000000000000000000AE2' and i.codestpro1=e3.codestpro1 and i.codestpro2=e3.codestpro2 and i.codestpro3=e3.codestpro3 and e3.codestpro1='00000000000000000000PROY1' and e3.codestpro2='0000000000000000000000AE2' and e3.codestpro3='0000000000000000346346456' and i.codestpro1=e4.codestpro1 and i.codestpro2=e4.codestpro2 and i.codestpro3=e4.codestpro3 and i.codestpro4=e4.codestpro4 and e4.codestpro1='00000000000000000000PROY1' and e4.codestpro2='0000000000000000000000AE2' and e4.codestpro3='0000000000000000346346456' and e4.codestpro4='00000000000000000000PROY1' and i.codestpro1=e5.codestpro1 and i.codestpro2=e5.codestpro2 and .codestpro3=e5.codestpro3 and i.codestpro4=e5.codestpro4 and i.codestpro5=e5.codestpro5 and e5.codestpro1='00000000000000000000PROY1' and e5.codestpro2='0000000000000000000000AE2' and e5.codestpro3='0000000000000000346346456' and e5.codestpro4='00000000000000000000PROY1' and e5.codestpro5='0000000000000000000000AE2' select p1.codest1,p1.denest1,p2.codest2,p2.denest2,p3.codest3,p3.denest3, p4.codest4,p4.denest4,p5.codest5,p5.denest5,e1.codestpro1,e1.denestpro1,e2.codestpro1,e2.codestpro2,denestpro2,e3.codestpro3,e3.denestpro3 from spe_relacion_es as i,sfp_estpro1 as e1,sfp_estpro2 as e2,sfp_estpro3 as e3,spe_estpro1 as p1, spe_estpro2 as p2,spe_estpro3 as p3,spe_estpro4 as p4,spe_estpro5 as p5 where i.codestpro1=e1.codestpro1 and e1.codestpro1='00000000000000000000PROY1' and i.codestpro2=e2.codestpro2 and e2.codestpro1='00000000000000000000PROY1' and e2.codestpro2='0000000000000000000000AE2' and i.codestpro1=e3.codestpro1 and i.codestpro2=e3.codestpro2 and i.codestpro3=e3.codestpro3 and e3.codestpro1='00000000000000000000PROY1' and e3.codestpro2='0000000000000000000000AE2' and e3.codestpro3='0000000000000000346346456' and p1.codest1=i.codest1 and p2.codest1=i.codest1 and p2.codest2=i.codest2 and p3.codest1=i.codest1 and p3.codest2 = i.codest2 and p3.codest3=i.codest3 and p4.codest1 = i.codest1 and p4.codest2=i.codest2 and p4.codest3=i.codest3 and p4.codest4=i.codest4 and p5.codest1=i.codest1 and p5.codest2=i.codest2 and p5.codest3=i.codest3 and p5.codest4=i.codest4 and p5.codest5=i.codest5