Hi,
Well, I consider it tricky because I've never done it before ... but
here we go:
I have a table with game results, like winning/losing teams,
winning/losing scores, etc, and I want to sort the table based on an new
(but hidden) attribute, say points = wins*3 - losses.
Somewhat Pseudo Code:
SELECT TeamName,TeamWins,TeamLosses FROM GameResults ORDER BY {Points =
TeamsWins*3 - TeamLosses}
Thanks for the help!
Cheers,
Camilo
--
+====================================================+
Camilo Rostoker
Web Developer
Scottsdale I.T. Consulting
camilo@stripped
http://www.scottsdale.ca/
+====================================================+
