[alma2]

جرب هذا الاستعلام بعد التعديل

كود :

SELECT Facture_L.Num_Vent,
      Facture_L.Num_Fact_Vent,
      Facture_L.ID_Prod,
      Facture_L.UM,
      UM.Nom_UM,
      CAST(CASE WHEN (Facture_L.UM = 1) THEN (Facture_L.Qte_V * 0.02) ELSE (Facture_L.Qte_V) END AS FLOAT) AS Qte,
      Facture_L.Prix_V
FROM   Facture_L
INNER JOIN UM ON Facture_L.UM = UM.ID_UM