OMG, sorry... forgot to post the query, here you go:

use corporerm

select datepart(year,M.DATAEMISSAO) AS ANO, DATEPART(MONTH,M.DATAEMISSAO) AS MÊS, M.NUMEROMOV AS NOTA,

(SELECT M.VALORLIQUIDO) AS 'VALOR TOTAL' FROM TITMMOV IM

INNER JOIN DNATUREZA D...