Query no viene nada

[[gluglu]]

Código SQL [-]
Select CAP.CD_FUNC "FUNCIONARIO",
FUNC.NOME "NOME",
ACUMULADO.DT_FUNC,
SUM(CAP.VL_BRUTO + CAP.VL_DESC_ACR) - COALESCE(DEVOLUCAO.DEV,0) "VENDA DIA",
SUM(CAP.VL_BRUTO + CAP.VL_DESC_ACR) - COALESCE(DEVOLUCAO.DEV,0) + COALESCE(ACUMULADO.ACUM,0) "VENDA ACUMULADA"
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 '2008-Mar-29' And '2008-Mar-31'
    Group By CP.CD_FUNC) "DEVOLUCAO"
  on(DEVOLUCAO.CD_FUNC = FUNC.CD_FUNC)
Left Join (Select VEN.CD_FUNC,
    VEN.DT_FUNC,
    Sum(VEN.VL_FUNC)"ACUM"
    Ffrom TB_SAC_FUNC_VEN VEN
    Where VEN.DT_FUNC Between '2008-Mar-29' And '2008-Mar-31'
    Group By VEN.CD_FUNC, VEN.DT_FUNC)"ACUMULADO"
  on(ACUMULADO.CD_FUNC = CAP.CD_FUNC)
Where ST_CANC = 0 and ((SR_NF = 'D2') or ((SR_NF = 'B2') And
  (CD_CFOP = 6102))) and DT_ENT between '2008-Mar-29' And '2008-Mar-31'
Group By CAP.CD_FUNC, FUNC.NOME, DEVOLUCAO.DEV, ACUMULADO.ACUM, ACUMULADO.DT_FUNC