try HAVING instead of WHERE (iirc) On Tue, May 15, 2012 at 1:12 PM, julianne anyim <julianneanyim@gmail.com> wrote:
Hello people,
I have a query in the form;
SELECT A, B, (C-D) AS E ...
I need to return only values where E<0 for instance. I know i can achieve this in php, but is there a way i can achieve it at the SQL level?
I have tried:
SELECT A, B, (C-D) AS E WHERE E<0
but i get an "ORA-00904: : invalid identifier" error. E is not recognized.
Any insights?
Thank you Julianne
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Best Regards, Christian Ledermann <*)))>{ If you save the living environment, the biodiversity that we have left, you will also automatically save the physical environment, too. But If you only save the physical environment, you will ultimately lose both. 1) Don’t drive species to extinction 2) Don’t destroy a habitat that species rely on. 3) Don’t change the climate in ways that will result in the above. }<(((*>