Thanks all. The problem was sloved. It update only the first value from source table to target table because of I have queried by right-click and select pane SQL. The...

Hello again,

I have try this query

UPDATE Orders

SET total_order_price =

(SELECT PO.total_pizza_price

FROM Pizzas_Ordered AS PO INNER JOIN

...