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 |