Need help to create a calculating trigger

[Harald Bacik]

Hey
I need some help please.
I have two tables, which are related to gether.
In Table A I have the following fields: ID, Article, Price
In Table B I have the following fields: ID, TableAID, CompanyID, stock, stockPrice

So, now I want create a trigger, which calculates the "stockprice" field after updating a row. I tried the following trigger, but this doesn't work:


CREATE DEFINER = 'myName'@'%' TRIGGER lagerwert_invwert
AFTER UPDATE
ON artikelstammdetails
FOR EACH ROW
BEGIN
Update B Set
lagwert = new.Stock*
(Select Distinct Price From
A Where A.ID=
new.TableAID),
END

Please, can anyone help me to get this working! - THX