Thread: 1054 Unknown column....
View Single Post
  #1  
Old 03-09-2007, 04:42 AM
Worlord Worlord is offline
Junior Member
  
Join Date: Nov 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Worlord is on a distinguished road
Default 1054 Unknown column....
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 --
Reply With Quote
  Webmaster Forums - View Single Post - 1054 Unknown column....
Thread: 1054 Unknown column....
View Single Post
  #1  
Old 03-09-2007, 04:42 AM
Worlord Worlord is offline
Junior Member
  
Join Date: Nov 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Worlord is on a distinguished road
Default 1054 Unknown column....
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 --
Reply With Quote