SQL problem!

[Eric]

I've got an SQL statement that is structured like this:

SELECT *, SUM([Score1]+[Score2]+[Score3]+[Score4]) AS Total
FROM buickclassic_pro
ORDER BY Total DESC;

For some reason, it keeps giving me an SQL error at line 1. This is exactly how MS Access structures the SQL statement as well, so is there something that MySQL doesn't like about it or what? Thanks a ton!

[Eric]

Thx Marty! Unfortunately, I've already tried that as well. I think it has something to do with the expression but I don't see it. I was just wondering if we could use the "AS" expression. I thought ALL SQL was valid with MySQL but I don't know for sure.

[Eric]

Thanks a bunch Marty....Gotta run for a few minutes and I'll get back to tell ya if it works. :)

[Eric]

UDAMAN! It was the brackets that was screwing me up. Sheesh!
Thanks Marty!