SELECT * FROM VIEW_ESTADISTICAS_PRESTACIONES_ECONOMICAS SELECT FILTRO.NOMBRE, FILTRO.TOTAL AS TOTAL_FILTRO, TOTAL.TOTAL FROM (SELECT MAX(PRE.PRE_NOMBRE) AS NOMBRE, COUNT(PRE.IDPRESTACION) AS TOTAL FROM SOLICITUD_SOL AS SOL INNER JOIN PRESTACION_PRE AS PRE ON PRE.IDPRESTACION = SOL.IDPRESTACION INNER JOIN NORMAPENSIONCESANTIA_NPC AS NPC ON NPC.IDNORMAPENSIONCESANTIA = SOL.IDNORMAPENSIONCESANTIA GROUP BY PRE.IDPRESTACION) AS FILTRO INNER JOIN (SELECT MAX(PRE.PRE_NOMBRE) AS NOMBRE, COUNT(PRE.IDPRESTACION) AS TOTAL FROM SOLICITUD_SOL AS SOL INNER JOIN PRESTACION_PRE AS PRE ON PRE.IDPRESTACION = SOL.IDPRESTACION INNER JOIN NORMAPENSIONCESANTIA_NPC AS NPC ON NPC.IDNORMAPENSIONCESANTIA = SOL.IDNORMAPENSIONCESANTIA GROUP BY PRE.IDPRESTACION) AS TOTAL ON FILTRO.NOMBRE = TOTAL.NOMBRE