Resolvi, pues com havia vendedores sin devolucion, estes estavam NULL e o NULL estava me matando. Entoces, hizo un COALESCE e resolvio. Mira la query abajo:
Cita:
SELECT
CAP.CD_FUNC "FUNCIONARIO",
FUNC.NOME "NOME",
SUM(CAP.VL_BRUTO + CAP.VL_DESC_ACR) -
COALESCE(DEVOLUCAO.DEV,0) "VENDA DIA"
FROM
TB_SAC_NF_CAPEADOR CAP
INNER JOIN
TB_SAC_FUNC FUNC
ON(FUNC.CD_FUNC = CAP.CD_FUNC)
LEFT JOIN
(SELECT
CP.CD_FUNC,
SUM(CP.VL_BRUTO + CP.VL_DESC_ACR)"DEV"
FROM
TB_SAC_NF_CAPEADOR CP
WHERE CP.SR_NF = 'E2' AND CP.ST_CANC = 0 AND
CP.DT_ENT BETWEEN '29-MAR-2008' AND '29-MAR-2008'
GROUP BY CP.CD_FUNC) "DEVOLUCAO"
ON(DEVOLUCAO.CD_FUNC = FUNC.CD_FUNC)
WHERE
ST_CANC = 0 AND
((SR_NF = 'D2') OR ((SR_NF = 'B2') AND (CD_CFOP = 6102))) AND
DT_ENT BETWEEN '29-MAR-2008' AND '29-MAR-2008'
GROUP BY
CAP.CD_FUNC,
FUNC.NOME,
DEVOLUCAO.DEV
|