i got 4 table which call addproduct, sellproduct, reportfoundproduct, productbalance
i want to make a trigger to update the balance quantity of stock in productbalance table after insert data to those three table (addproduct, sellproduct, reportfoundproduct)
below is my trigger :
AFTER INSERT ON `user`.`addproduct`
FOR EACH ROW
UPDATE productbalance SET Quantity_OnHand = (select sum(Product_OrderQuantity) from (select * from addproduct) as temp)- (select sum(Sale_Quantity) from (select * from sellproduct) as temp2 )+(select sum(BoL_Product_Quantity) from (select * from reportfoundproduct) as temp3)where Product_ID= productbalance.Product_ID;
But i face the problem that after i update the data, the value turn to NULL....
whats the problem ?????????? urgent ~~~~!!!