Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- This is a reall simple SQL question
January 24, 2006, 6:01 pm
rate this thread
Username Varchar 255
Price Decimal 10,2
I want to use a select query to retrieve the total of all the price
fields for a specific user.
"Select sum(price) as total from orders where username = 'XXX'"
Which works in other Databases I've used, but MySQL belches the query
back at me and tells me that it doesn't work.
How do I do this?
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum