Query problem

[Mr.Rubi]

Query the database with merging records

Hello In the database the data is stored as a table: [2] How to create a query in Wappler, so that the output is formed according to the condition - if the records have the same names field 1 and field 2, the records are combined into one, and the values of the fields with the number of units are added. It looks like this: [3] Strongly do not scold. So far I am weak in working with the database. Thanks in advance for help.

Look at this topic. I needed to something like that. I just implemented the recommendations and the solution worked perfectly. Perhaps will helpful and than the will help you.