REG / VL_BC_CRED
select C.participapiscofins,A.CFOP, C.nat_bc_cred, sum(A.BASEPIS) as basepis
from produtos_notaentrada A 
inner join lventradas B on A.primaria=B.primaria
inner join cfop C on A.cfop = C.cfop
where B.entrada between ('2013-10-01') and ('2013-10-31') and B.cancelado='N'
group by A.cfop, C.nat_bc_cred, C.PARTICIPAPISCOFINS order by C.nat_bc_cred