select A.id_produto, A.cst_pis, A.cfop, P.participapiscofins, sum(A.basepis) 
from produtos_notasaida A inner join lvsaidas B on A.primaria=B.primaria left join cfop P 
on A.cfop=P.cfop where B.emissao between ('2013-02-01') and ('2013-02-28') and B.cancelado='N' 
group by A.cfop, A.cst_pis, P.participapiscofins