select * from movcartao a
inner join cupons b
	on a.coo = b.cupom
	and a.CAIXA = b.CAIXA
inner join totais_por_finalizadora c
	on c.CAIXA = b.CAIXA 
	and c.NFCE = b.NFCE
	and c.CUPOM = a.COO
	and c.ID_ADM = a.ID_ADMINISTRADORA
	and c.VALOR = a.VALOR
where b.CSTAT = 217
and b.EMISSAO between :data1 and :data2

/*
update movcartao a
inner join cupons b
	on a.coo = b.cupom
	and a.CAIXA = b.CAIXA
inner join totais_por_finalizadora c
	on c.CAIXA = b.CAIXA 
	and c.NFCE = b.NFCE
	and c.CUPOM = a.COO
	and c.ID_ADM = a.ID_ADMINISTRADORA
	and c.VALOR = a.VALOR
set a.num_nfce = b.NFCE
where b.CSTAT = 217
and b.EMISSAO between :data1 and :data2

*/