If i'm not wrong, below query should do the job:
UPDATE Article t1 SET stock = (SELECT [received goods] AS stock FROM [Order] t2 WHERE t2.articlenumber = t1.articlenumber)
It's strongly recommended to change the name of
Order
table, because it is one of
reserved words of Oracle database[
^]! You can use
Orders
instead.