hi all, first post, and i hope it hasn't been covered last week or something!
is it possible to reference a newly created column in a sql function, for example: (simplified version compared to real problem!) select (id * 5) AS score1, (id * 10) AS score2, (score1 + score2) AS finalscore score1 and score2 can't be referenced as it comes back with an unknown column name. is there any sneaky way around this? my scoring functions are a lot more complicated and can't be pregenerated. I'd like to have a total score but also expose the component scores that make up the total thanks for any help paul --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
