Each great god: how to find the data from the "form" to not repeat the material number, and then different material number in the "record" the data in sum, to create a new table query results, after the table name "query result table below" zha write SQL? Thank you very much!

CodePudding user response:

Establish a lookup table, INSERT INTO the query result table (material, cumulants)
The SELECT material, the SUM (quantity) AS cumulant
The FROM record
GROUP BY the material number