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