12/11/2021 01:09:45 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Report MÉTODO->uf_listadobanco_gendisk_agrupado ERROR->Invalid query: ERROR: subquery in FROM must have an alias LINE 14: ( ^ HINT: For example, FROM (SELECT ...) [AS] foo. Whole query: SELECT codper, cedper, nomper, apeper, nacper, codcueban, tipcuebanper, codnom, desnom, tippernom, sum(monnetres) AS monnetres FROM ( SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.nacper, sno_hpersonalnomina.codcueban, sno_hpersonalnomina.tipcuebanper, sno_hnomina.codnom, sno_hnomina.desnom, sno_hnomina.tippernom, (sno_hresumen.monnetres) as monnetres FROM sno_personal, sno_hpersonalnomina, sno_hresumen, sno_hnomina WHERE sno_hpersonalnomina.codemp='0001' AND sno_hpersonalnomina.codnom>='0001' AND sno_hpersonalnomina.codnom<='0001' AND sno_hpersonalnomina.anocur = '2021' AND sno_hresumen.codperi>='019' AND sno_hresumen.codperi<='020' AND sno_hresumen.monnetres > 0 AND sno_hpersonalnomina.pagbanper=1 AND sno_hpersonalnomina.pagtaqper=0 AND sno_hpersonalnomina.pagefeper=0 AND sno_hpersonalnomina.codban='008' AND (sno_hpersonalnomina.staper='1' OR sno_hpersonalnomina.staper='2') AND (sno_personal.situacion!='2' or sno_personal.situacion IS NULL) AND sno_hpersonalnomina.codemp = sno_hresumen.codemp AND sno_hpersonalnomina.anocur = sno_hresumen.anocur AND sno_hpersonalnomina.codperi = sno_hresumen.codperi AND sno_hpersonalnomina.codnom = sno_hresumen.codnom AND sno_hpersonalnomina.codper = sno_hresumen.codper AND sno_hpersonalnomina.codemp = sno_hnomina.codemp AND sno_hpersonalnomina.anocur = sno_hnomina.anocurnom AND sno_hpersonalnomina.codperi = sno_hnomina.peractnom AND sno_hpersonalnomina.codnom = sno_hnomina.codnom AND sno_personal.codemp = sno_hpersonalnomina.codemp AND sno_personal.codper = sno_hpersonalnomina.codper ORDER BY sno_hpersonalnomina.tipcuebanper, sno_personal.codper ) GROUP BY codper, cedper, nomper, apeper, nacper, codcueban, tipcuebanper, codnom, desnom, tippernom ORDER BY tipcuebanper,codper