Home > database >  2 tables summarizing query after subtraction to save the results into another table
2 tables summarizing query after subtraction to save the results into another table

Time:10-06




First, sales quantity list
Second, pin number back table
The third figure for sales - pin back

Have according to the number of article number will each summary together, to save 2 all by subtracting again won't get in another table, beg god for help, thank you,

CodePudding user response:

Can put the summary data are stored as temporary table, associated with a temporary table subtraction can then insert was carried out on the table
  • Related