ERRO VL_BC_PIS_TOT
select  A.CFOP, sum(A.BASEPIS), C.nat_bc_cred, C.PARTICIPAPISCOFINS 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 ('2012-02-01')
 and ('2012-02-29') and B.cancelado='N' group by A.CFOP, C.nat_bc_cred, C.PARTICIPAPISCOFINS  order by C.nat_bc_cred;