Ayuda con QUERY SQL

SELECT d.NOFACTURA, CAST(d1.FECHAFACTURA AS DATE) AS FECHAFACTURA, d.CLAVEPROD, d.SUBTOTAL, ISNULL(d5.CANTIDAD,0) AS IMPUESTO, d.TC, d.CLAVEMONEDA, d3.LINEA, d2.DESCRIPCION
FROM
    dbo.FACPARTIDAS d
    INNER JOIN dbo.FACTURAS d1 ON (d.NOFACTURA=d1.NOFACTURA)
    INNER JOIN dbo.PRODUCTOS d4 ON (d.CLAVEPROD=d4.CLAVEPROD)
    INNER JOIN dbo.LINEAS d3 ON (d4.CLAVELINEA=d3.CLAVELINEA)
    INNER JOIN dbo.TFAMILIAS d2 ON (d4.FAMILIA=d2.CLAVE)
    LEFT OUTER JOIN dbo.FACIMPUESTOSP d5 ON (d1.NOFACTURA=d5.NOFACTURA)
    WHERE (d.NOFACTURA LIKE '%A-%' OR d.NOFACTURA LIKE '%E-%'
    OR d.NOFACTURA LIKE '%T-%' OR d.NOFACTURA LIKE '%REM-%') AND D1.ESTATUS<>'CANCELADA'
    ORDER BY D.NOFACTURA ASC

SELECT
    d.NOFACTURA AS FACTURA, d.PARTIDA, d.TC AS TIPOCAMBIO, d.CLAVEPROD AS PRODUCTO, (d.CANTIDAD*d1.FACTOR) AS TOTALKG,  d.SUBTOTAL, CAST(D2.FECHAFACTURA AS DATE)AS FECHA, d2.ESTATUS, d2.MONEDA, d3.DESCRIPCION AS FAMILIA, d4.LINEA
    FROM
    dbo.FACPARTIDAS d
    INNER JOIN dbo.PRODUCTOS d1 ON (d.CLAVEPROD=d1.CLAVEPROD)
    INNER JOIN dbo.FACTURAS d2 ON (d.NOFACTURA=d2.NOFACTURA)
    INNER JOIN dbo.TFAMILIAS d3 ON (d1.FAMILIA=d3.CLAVE)
    INNER JOIN dbo.LINEAS d4 ON (d1.CLAVELINEA=d4.CLAVELINEA)
    WHERE (d.NOFACTURA NOT LIKE '%REMB-%') AND ESTATUS<>'CANCELADA'
    ORDER BY D.NOFACTURA,D2.MONEDA,D4.LINEA ASC

    SELECT d.FACTURA, d.PARTIDA, d.TIPOCAMBIO, d.PRODUCTO, d.TOTALKG, d.SUBTOTAL, d.FECHA, d.ESTATUS, d.MONEDA, d.FAMILIA, d.LINEA, SUM(SUBTOTAL+ISNULL(d1.CANTIDAD,0))AS TOTALPARTIDA
    FROM
    dbo.QRVENTASFAM2 d
    LEFT JOIN dbo.FACIMPUESTOSP d1 ON (d.FACTURA=d1.NOFACTURA) AND (d.PARTIDA=d1.PARTIDA)   
    WHERE FECHA BETWEEN '2019-07-01' AND '2019-12-31' 
    GROUP BY d.FACTURA, d.PARTIDA, d.TIPOCAMBIO, d.PRODUCTO, d.TOTALKG, d.SUBTOTAL, d.FECHA, d.ESTATUS, d.MONEDA, d.FAMILIA, d.LINEA