select votes, rating, votes/sum(votes) as percentage
if that doesn't work, then you may need to do a nested select statement, where the inner one gets the sum() first.
and whats client code?
Reputation Points: 92
Solved Threads: 51
Practically a Posting Shark
Offline 856 posts
since Mar 2004