17/06/2021 13:19:46 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->covensol_scv_c_viaticos Personal MÉTODO->ConsultaResumenAsignacionesSucursal ERROR->Invalid query: ERROR: syntax error at or near "WHERE" LINE 28: WHERE sv.codemp='0001' ^ Whole query: SELECT sv.codsuc,suc.sigsuc,dt.proasi,dt.codasi, (CASE WHEN dt.proasi = 'TVS' THEN tvs.dentar WHEN dt.proasi = 'TRP' THEN trp.dentra WHEN dt.proasi = 'TOA' THEN toa.denotrasi WHEN dt.proasi = 'TDS' THEN tds.dentar ELSE '' END) as dentar, sum(dt.monasig) as monasig, sum(dt.canasi) as canasi FROM scv_dt_asignaciones dt LEFT JOIN scv_solicitudviatico sv ON sv.codsolvia=dt.codsolvia LEFT JOIN cxc_sucursales suc ON suc.codsuc = sv.codsuc LEFT JOIN scv_tarifas tvs ON dt.codemp=tvs.codemp AND dt.codasi=tvs.codtar AND dt.proasi='TVS' LEFT JOIN scv_transportes trp ON dt.codemp=trp.codemp AND dt.codasi=trp.codtra AND dt.proasi='TRP' LEFT JOIN scv_otrasasignaciones toa ON dt.codemp=toa.codemp AND dt.codasi=toa.codotrasi AND dt.proasi='TOA' LEFT JOIN scv_tarifakms tds ON dt.codemp=tds.codemp AND dt.codasi=tds.codtar AND dt.proasi='TDS' ORDER BY sv.codsuc,dt.proasi,dt.codasi WHERE sv.codemp='0001' GROUP BY 1,2,3,4,5 ORDER BY dt.proasi,dt.codasi