Preparation de la Commande
Erreur SQL ! SELECT cip_prod,prod_factures.nom_prod,prod_factures.code_uv,libelle_civilite,assure.nom,assure.prenom,nolot,dbo.formatdate(date_perim,'dd/mm/yyyy') as date_perim,
assure.index_assure,dbo.formatdate(factures.DateFacture,'dd/mm/yyyy'),nolot_pdt.qte,prod_factures.quantite,prod_factures.ordre_prod,
factures.noBL,factures.index_typefacture,nolot_pdt.colis,libelle_geo,nb_stock,factures.index_liv_veto
FROM ((prod_factures left join ((produit left join stock on produit.code_uv=stock.code_uv) left join geo on produit.code_geo=geo.code_geo) on prod_factures.code_uv=produit.code_uv)
left join nolot_pdt on prod_factures.Nofacture=nolot_pdt.nofacture and prod_factures.code_uv=nolot_pdt.code_uv)
left join (factures 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= and cip_prod<>'*' and cip_prod<>'/'
order by CASE WHEN colis is null or colis=0 THEN 9999 ELSE colis END,libelle_geo,prod_factures.ordre_prod,nolot |