newboi

Unfortunately, I never found out how to do it

Thanks for the response vtxyzzy, unfortunately, it hasn’t worked; i.e. It doesn’t group and add the prices.

Hi vtxyzzy, many thanks for your response and apologies for the delay – I was away.

I sorted it before I saw your response but you are very much on point. Many thanks again. I hope this will help someone else in the future.

I have run into another problem however; the query above returns something similar to this:

+---------------+-----------------+
| Type          |  Price          |
+---------------+-----------------+
| Music         |  19.99          |
| Music         |   3.99          |
| Music         |  21.55          |
| Toy           |  89.95          |
| Toy           |   3.99          |
+---------------+-----------------+

My problem is how to group the products by type, so that it returns a single product type and total price for each product type e.g:

Music | 45.53
Toy | 93.94 and so on.

Once again, many thanks

Cheers!