Erreur SQL !
SELECT F.NoFacture, dbo.formatdate(F.DateFacture,'dd/mm/yyyy') as DateFacture, dbo.formatdate(F.DateFacture,'yyyymmdd') as DateFactureFormatee, F.renouvel, dbo.formatdate(F.DateOrdonnance,'dd/mm/yyyy') as DateOrdonnance, Operateur.code_ope, beneficiaire.nom as benef_nom, beneficiaire.prenom as benef_prenom, beneficiaire.noss as benef_noss, beneficiaire.cless as benef_cless, beneficiaire.datenaissance as benef_datenaissance, beneficiaire.rang,assure.nom as ass_nom, assure.prenom as ass_prenom, assure.noss,assure.cless, assure.datenaissance, medecins.nom as med_nom, medecins.prenom as med_prenom, medecins.identifiant, medecins.cleid, centres.caissegestion, centres.centregestion, centres.regime, centres.code_centre,centres.nom as centre_nom, mutuelles.code_mutuelle, mutuelles.codevitale, F.partamoreel, F.partamcreel, F.montantTP,CAST(priseencharge as varchar(8000)) as priseencharge,F.index_assure, F.index_medecin, F.index_typefacture,crl.ModeSecurisation,crl.recycle,dbo.formatdate(crl.DateFormatage,'yyyymmddhhmiss') as DateFormatage FROM ((factures as F left join crl on F.NoFacture=crl.NoFacture) left join operateur on F.num_ope=Operateur.num_ope) LEFT JOIN assure AS beneficiaire ON (F.index_assure = beneficiaire.index_assure) LEFT JOIN assure ON (beneficiaire.noss = assure.noss AND beneficiaire.noss <> '' and assure.lien = 'ASSURE') LEFT JOIN centres ON (F.index_centre = centres.index_centre) LEFT JOIN mutuelles ON (F.index_mutuelle = mutuelles.index_mutuelle) LEFT JOIN medecins ON (F.index_medecin = medecins.index_medecin) WHERE F.NoFacture= AND (assure.lien='ASSURE' or assure.lien is null) and crl.nofacture<>0