como unir dos consultas

[edgar_cln]

Código MySQL:

SELECT T.CSE_PROD, T.CVE_PROD, T.DESC_PROD, T.UNIDAD, SUM(T.CANT_SURT) AS CANTIDAD, SUM(T.VALOR_PROD) AS VALOR, SUM(T.SUBT_PROD) AS TOTALVALOR
FROM (
SELECT  REMD.NO_REM, REMD.SUC_REM as ho, REMD.CSE_PROD as clase, REMD.CVE_PROD as clave, REMD.UNIDAD, REMD.CANT_SURT, REMD.VALOR_PROD, REMD.SUBT_PROD, PRODUCTO.DESC_PROD as descripcion,
    REMC.STATUS_REM, REMC.FALTA_REM, REMC.SUC_REM
    #SUM(REMD.CANT_SURT) AS SUMCANTSURT, ROUND((SUM(REMD.VALOR_PROD)),2) AS SUMVALORPROD, ROUND((SUM(REMD.SUBT_PROD)),2) AS SUMSUBT_PROD,
    #ROUND((SUM(REMD.SUBT_PROD) / SUM(REMD.CANT_SURT)),2) AS DIVISION
    FROM REMD
    LEFT JOIN PRODUCTO ON REMD.CVE_PROD=PRODUCTO.CVE_PROD
    LEFT JOIN REMC ON REMD.NO_REM=REMC.NO_REM
    WHERE REMD.SUC_REM='MOC' AND REMC.SUC_REM='MOC' AND (REMC.STATUS_REM='Emitida' OR REMC.STATUS_REM='Facturada' OR REMC.STATUS_REM='Parcial') 
    AND REMC.FALTA_REM BETWEEN '2011-09-01' AND '2011-09-30'  
    #GROUP BY REMD.CVE_PROD
UNION ALL
SELECT  NVENTASD.CVE_SUC, NVENTASD.NO_FAC, NVENTASD.CSE_PROD AS clase, NVENTASD.CVE_PROD AS clave, NVENTASD.UNIDAD, NVENTASD.CANT_SURT, NVENTASD.VALOR_PROD, NVENTASD.SUBT_PROD, PRODUCTO.DESC_PROD AS descripcion,
    NVENTASC.STATUS_FAC, NVENTASC.FALTA_FAC, NVENTASC.CVE_SUC
    #SUM(NVENTASD.CANT_SURT) AS SUMCANTSURT, ROUND((SUM(NVENTASD.VALOR_PROD)),2) AS SUMVALORPROD, ROUND((SUM(NVENTASD.SUBT_PROD)),2) AS SUMSUBT_PROD,
    #ROUND((SUM(NVENTASD.SUBT_PROD) / SUM(NVENTASD.CANT_SURT)),2) AS DIVISION
    FROM NVENTASD
    LEFT JOIN PRODUCTO ON NVENTASD.CVE_PROD=PRODUCTO.CVE_PROD
    LEFT JOIN NVENTASC ON NVENTASD.NO_FAC=NVENTASC.NO_FAC
    WHERE NVENTASD.CVE_SUC='MOC' AND NVENTASC.CVE_SUC='MOC' AND NVENTASC.STATUS_FAC='Pagada' AND NVENTASC.FALTA_FAC BETWEEN '2011-09-01' AND '2011-09-30'
    #GROUP BY NVENTASD.CVE_PROD
    )T
    GROUP BY T.CVE_PROD;
 

la hize asi, despues de varios intentos que me marcaban error, esta tardo un buen pero me arrojo este error:

Error Code : 1054
Unknown column 'T.CSE_PROD' in 'field list'
(0 ms taken)