Re: SELECT AS and WHERE problem in query
Well I attempted to implement your approach but since it involves grouping only the first of each calculation was returned. That is, many items would have been returned with say an item_multiplied of 88.70 but only the first one was displayed (via PHP).
The solution to my problem involved putting the actual formula in the where claus...
SELECT item_desc, ROUND(item_price*10,1) AS item_multipied FROM items WHERE ROUND(item_price*10,1) > 10 AND ROUND(item_price*10,1) < 100
Thanks for your help!
Subject
Written By
Posted
Re: SELECT AS and WHERE problem in query
June 15, 2005 08:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.