UPDATE article SET Stock_actuel = Stock_depart + Stock_Mouvement FROM article INNER JOIN (SELECT articleID, Sum(Qt_Entr_Mouv)-Sum(Qt_Sorti_Mouv) AS Stock_Mouvement FROM Mouvement GROUP BY articleID) Mouvement ON articles.articleID = Mouvement.articleID WHERE Article.ArticleID = ArticleID