Hello community,
I am trying to update the entry with the ID "134" of the table "tbl_offers" with the sum of its Products (found in table "tbl_products").
That's what i got so far, but it does not work...
tbl_offers:Code:UPDATE tbl_offers SET tbl_offers.total = (SELECT SUM(tbl_products.price) FROM tbl_products WHERE tbl_products.IDoffer = 134) WHERE tbl_offers.ID = 134;
ID total 134 ??? (should be 15) ...
tbl_products:
ID IDoffer price 1 134 10 2 134 5 3 999 80 ...
Would be thankful for any suggestions/help.
Greetings from Bavaria, Germany
Flo