Duda con query

[Paulao]

Que tengo que hacer para la query abajo, mostrar los vendedores que no tuvo devolucion? O sea, como estas, solo mostra el vendedor que tuvo devolucion, los demas no mostra, pero necessito hacer que lo mostre a todos, los que tiene y los que no tiene devolucion. Gracias.

SELECT
CAP.CD_FUNC "FUNCIONARIO",
FUNC.NOME "NOME",
SUM(CAP.VL_BRUTO + CAP.VL_DESC_ACR) - DEVOLUCAO.DEV "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

[Paulao]

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:

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