1054 Unknown column....

[Worlord]

Hi guys,
I want to do a query like this:
SELECT value1+value2 AS result, SQRT(result) FROM example_table;
I wana construct a new column 'result' and continue to work with this new value in the same query. It should be possible to achieve this somehow, but the way I put it above didn't work. The MySQL Query Browser shows "1054 Unknown column 'result'". Can anyone give me a hint?
Thanks a lot! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[rian]

Try this:

select SQRT(value1+value2) from example_table; -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --