Posologie pour la facture Erreur SQL !
SELECT nom_prod,codesituation,code_uv,libelle_civilite,assure.nom,assure.prenom,medecins.nom,medecins.prenom, dbo.formatdate(factures.DateOrdonnance,'dd/mm/yyyy'),assure.index_assure,dbo.formatdate(factures.DateFacture,'dd/mm/yyyy'),prod_factures.NoFacture FROM prod_factures left join ((factures left join medecins on factures.index_medecin=medecins.index_medecin) left join (assure left join civilites on assure.id_civilite=civilites.id_civilite) on factures.index_assure=assure.index_assure) on prod_factures.NoFacture=factures.NoFacture where prod_factures.NoFacture in () and codesituation<>'00000' and cip_prod<>'*' and cip_prod<>'/' and codeacte not in ('HC','HDR','HDA','HDE') order by ordre_prod