Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- need help constructing a query
February 16, 2007, 8:58 am
rate this thread
i have a table like this:
product id | product name | product price
the product name and product price fields both contain duplicate
1 | socks | 23
3 | shoes | 18
2 | socks | 24
what i need to do is work out the total of the price field for each
value of the name field.
so a list can be displayed like:
socks | 47
shoes | 18
can anyone help with this?
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum