Tenta isso aqui Larissa.
SELECT
TMOV.CODTMV AS [MOVIM.],
TMOV.NUMEROMOV AS [N° NF],
TMOV.DATAEMISSAO [DATA EMISSAO],
FCFO.NOME AS [CLIENTE/FORNECEDOR],
TMOV.VALORLIQUIDO AS [VALOR BRUTO],
ISNULL(X.VALORICMS,0) AS [VALOR ICMS],
ISNULL(X.VALORICMSST,0) AS [VALOR ICMSST],
ISNULL(X.VALORIPI,0) AS [VALOR IPI],
ISNULL(X.VALORPIS,0) AS [VALOR PIS],
ISNULL(X.VALORCOFINS,0) AS [VALOR COFINS]
FROM TMOV INNER JOIN FCFO
ON FCFO.CODCFO=TMOV.CODCFO
INNER JOIN
(SELECT TMOV.IDMOV,TMOV.NUMEROMOV,
CASE WHEN TTRBMOV.CODTRB = 'ICMS' THEN SUM(VALOR) END AS VALORICMS,
CASE WHEN TTRBMOV.CODTRB = 'ICMSST' THEN SUM(VALOR) END AS VALORICMSST,
CASE WHEN TTRBMOV.CODTRB = 'IPI' THEN SUM(VALOR) END AS VALORIPI,
CASE WHEN TTRBMOV.CODTRB = 'PIS' THEN SUM(VALOR) END AS VALORPIS,
CASE WHEN TTRBMOV.CODTRB = 'COFINS' THEN SUM(VALOR) END AS VALORCOFINS
FROM TTRBMOV,TMOV
WHERE TTRBMOV.IDMOV = TMOV.IDMOV
GROUP BY TMOV.IDMOV,TMOV.NUMEROMOV,TTRBMOV.CODTRB) X
ON X.IDMOV = TMOV.IDMOV
WHERE
(TMOV.CODTMV IN ('2.2.01','2.2.22','2.2.23'))
AND (TMOV.DATAEMISSAO>@datainicio AND TMOV.DATAEMISSAO<@datafinal)
AND ( ISNULL(X.VALORICMS,0)+
ISNULL(X.VALORICMSST,0)+
ISNULL(X.VALORIPI,0)+
ISNULL(X.VALORPIS,0)+
ISNULL(X.VALORCOFINS,0) ) > 0
ORDER BY FCFO.NOME, TMOV.DATAEMISSAO
Responde para nós se funcionou por favor.
Wiliam.