sales (scriptname,accnum,remainingshares)
transac (scriptname,accnum,sharesbought,sharesold)
remainingshares = sharesbough - sharesold
INSERT INTO sales(accnum, scriptname, remainingshares) select accnum,scriptname,sharesbought-sharesold from transac
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)