sql = select epresc_num from factures left join (crl left join lotFSE on crl.NoLot=lotFSE.NoLot) on factures.nofacture=crl.nofacture Where epresc_num<>0 and epresc_etat<>'T'<BR>sql = insert into m01eprx (eprx_ind,eprx_ente_num,eprx_epre_num,eprx_etat,eprx_dt_trans,eprx_id_epre,eprx_num_facture,eprx_num_lot,eprx_dt_lot,eprx_nb_fac,eprx_pres_rpps,eprx_pres_rppsremp,eprx_pres_spe,eprx_pres_nom,eprx_pres_prenom,eprx_pres_am,eprx_pres_finess,eprx_pat_insi,eprx_pat_nir_bene,eprx_pat_nir_assu,eprx_pat_rang,eprx_pat_nele,eprx_pat_nom,eprx_pat_prenom,eprx_pat_regine,eprx_pat_orga,eprx_pat_centre,eprx_pat_nomusag,eprx_exe_rpps,eprx_exe_rppsremp,eprx_exe_spe,eprx_exe_nom,eprx_exe_prenom,eprx_exe_am,eprx_exe_finess,eprx_exe_date,eprx_exe_heure,eprx_essai) values (1,55489,9,'1','','0444A2TN0ZGUFGAUAT','0000-8592','000','',,'10100907624','','01','HUREL','SOPHIE','491078580','','156064900728444','156064900728444','156064900728444','1','19560628','BRIERE','ROBERT','01','491','3421','BRIERE','99900063290','','50','','','492014899','','20250826','1640',1)<BR>Erreur SQL !<br>insert into m01eprx (eprx_ind,eprx_ente_num,eprx_epre_num,eprx_etat,eprx_dt_trans,eprx_id_epre,eprx_num_facture,eprx_num_lot,eprx_dt_lot,eprx_nb_fac,eprx_pres_rpps,eprx_pres_rppsremp,eprx_pres_spe,eprx_pres_nom,eprx_pres_prenom,eprx_pres_am,eprx_pres_finess,eprx_pat_insi,eprx_pat_nir_bene,eprx_pat_nir_assu,eprx_pat_rang,eprx_pat_nele,eprx_pat_nom,eprx_pat_prenom,eprx_pat_regine,eprx_pat_orga,eprx_pat_centre,eprx_pat_nomusag,eprx_exe_rpps,eprx_exe_rppsremp,eprx_exe_spe,eprx_exe_nom,eprx_exe_prenom,eprx_exe_am,eprx_exe_finess,eprx_exe_date,eprx_exe_heure,eprx_essai) values (1,55489,9,'1','','0444A2TN0ZGUFGAUAT','0000-8592','000','',,'10100907624','','01','HUREL','SOPHIE','491078580','','156064900728444','156064900728444','156064900728444','1','19560628','BRIERE','ROBERT','01','491','3421','BRIERE','99900063290','','50','','','492014899','','20250826','1640',1)<br>Erreur de syntaxe près de ''10100907624','','01','HUREL','SOPHIE','491078580','','156064900728444','1560649' à la ligne 1