psingla (6/26/2013)

---

select UNITE_COUT_MATERIEL from DIM_INTER_MATERIEL

select (SUPERFICIE_INTER_CULTURE / SUPERFICIE_INTER) * QUANTITE_MATERIEL from FACT_INTERVENTION inter,DIM_INTER_MATERIEL mat

where inter.ID_INTER=mat.ID_INTER

both the queries should return only single value..Use top 1