This is a reall simple SQL question

[furby]

I have a table with the structure of something like this :
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.

I tried:
"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?

[Bill Karwin]

"furby" <fc********@peoplepc.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

"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.

That looks all right to me. What exact error message do you see?

What version of MySQL are you using? What server operating system?

Is that the whole SQL query you are executing, or is it part of a subquery?

Regards,
Bill K.