como unir dos consultas

[edgar_cln]

Gracias Leo, este puente me ayudo mucho a relajarme y a pensar y me quedo por finnn, comparto la ideaaa

Código MySQL:

SELECT T.NUMERO, T.SUCURSAL, T.CLASE, T.CLAVE, T.UNIDAD, ROUND((SUM(CANT_SURT)),2) CANTIDADTOTAL, ROUND((SUM(SUBT_PROD) / SUM(CANT_SURT)),2) AS DIVIDOS, ROUND((SUM(SUBT_PROD)),2) TOTAL, T.DESCRIPCION,
        T.STATU, T.FECHA, T.SUC, ROUND((SUM(SUBT_PROD) / SUM(CANT_SURT)),2) AS DIVIDOS
    FROM 
(SELECT  REMD.NO_REM AS NUMERO, REMD.SUC_REM AS SUCURSAL, 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 AS STATU, REMC.FALTA_REM AS FECHA, REMC.SUC_REM AS SUC
        #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.NO_FAC AS NUMERO, NVENTASD.CVE_SUC AS SUCURSAL, 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 AS STATU, NVENTASC.FALTA_FAC AS FECHA, NVENTASC.CVE_SUC AS 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
        )as T
    GROUP BY T.CLAVE ORDER BY T.CLAVE
 

muchas gracias leo que sin tu ayuda no podia haberlo logrado, le debo una pisteada compaaa jaja