Data e Ano

[rmanParticipante]

@Ronnie Von Pereira Lopes

Creio que seja isso:


SELECT TMOV.CODCCUSTO,
COALESCE(SUM(CASE WHEN EXTRACT(YEAR FROM TMOV.DATAEMISSAO) = 2009 THEN (T.QUANTIDADE * T.PRECOUNITARIO) END), 0) "2009"
FROM TMOV
INNER JOIN TITMMOV T ON T.CODCOLIGADA = TMOV.CODCOLIGADA AND T.IDMOV = TMOV.IDMOV
WHERE TMOV.CODCCUSTO LIKE '_.____.__'
AND TMOV.CODTMV IN ('1.2.01','1.2.02','1.2.03','1.2.04','1.2.05','1.2.06','1.2.09','1.2.10'
,'1.2.11','1.2.12','1.2.14','1.2.15','1.2.16','1.2.20','1.2.21','1.2.25')
GROUP BY TMOV.CODCCUSTO