Hi,
I have 3 tables: Movimentos, Compras, Vendas
The table Movimentos stores all the data about buying and selling stocks.
When i want to sell some stock, my code do the following:
1- Selects the stocks i want from Movimentos and copy all the records to table Compras and delete them from table...