Hi there!
I have a database containing records like these:
ID Name Qty Price
1 Prod1 5 15
2 Prod2 10 10
3 Prod1 10 15
4 Prod1 5 10
I have to make a query to obtain the following result:
Name Qty Price
Prod1 15 15
Prod1 5 10
Prod2 10 10
(Cumulate the quantities of records with the same Name AND Price)
Thank you in advance!
I have a database containing records like these:
ID Name Qty Price
1 Prod1 5 15
2 Prod2 10 10
3 Prod1 10 15
4 Prod1 5 10
I have to make a query to obtain the following result:
Name Qty Price
Prod1 15 15
Prod1 5 10
Prod2 10 10
(Cumulate the quantities of records with the same Name AND Price)
Thank you in advance!