T
tl_lyq
Unregistered / Unconfirmed
GUEST, unregistred user!
dm.Exesql('UPDATE Sellers inner join (SELECT Seller_ID, SUM(Bonus) AS bonus FROM Sale_Details where year(Sale_Month)='''+year+''' and month(Sale_Month)='''+month+''' GROUP BY Seller_ID) b on Sellers.id = b.seller_id SET total_income = b.bonus where year(Sale_Month)='''+year+''' and month(Sale_Month)='''+month+''' ');