Dê uma olhada se assim resolve
select pcmov.codprod,
pcmov.codst,
max(pcmov.dtmov),
pcmov.numnota
from pcmov
where codfiscal in (1102,2102)
and dtmov between ’01/10/2007′ and ’30/11/2008′
group by pcmov.codprod,
pcmov.codst,
pcmov.numnota
order by codprod
