INSERT INTO ReleveBanque (ID_COMPTE, CLE_BANQUE, DATE_OPERATION, DATE_VALEUR, LIBELLE_OPERATION, DEBIT, CREDIT, SOLDE) SELECT * From ( Select ReleveBq_Tampon.ID_COMPTE, CLE_BANQUE, DATE_COMPTABLE, DATE_PIECE, LIBELLE, ABS(DEBIT), ABS(CREDIT), SOLDE From ReleveBq_Tampon ) AS temp where not exists (select CLE_BANQUE from ReleveBanque where CLE_BANQUE = temp.CLE_BANQUE); Truncate table ReleveBq_Tampon; UPDATE ReleveBanque SET MONTANT_RAPPRO = (SELECT SUM(RapproBancaire.MONTANT_SIGNE) From RapproBancaire WHERE RapproBancaire.ID_RELEVE = ReleveBanque.ID_RELEVE) WHERE ReleveBanque.ETAT = 0; UPDATE ReleveBanque SET ECART = (DEBIT-CREDIT+MONTANT_RAPPRO) WHERE ReleveBanque.ETAT = 0; INSERT INTO JournalLog (DATE, EVENEMENT, OPERATEUR) Values(CURTIME(), 'ReleveBq2', 'Bouton'); CallBack URL: Banq_ReleveBq.php?msg=10