Two possible answers : 42 and inline views. >----- Original Message ----- >From: Zsolt Csillag <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Thu, 19 Dec 2002 05:43:55 > >Hi, > > >The following select does not work, I get ORA-00904 >error message that >the AgentShare column does not exists. >It would be painful to write down every calculation >many times because I can't >make a reference to a previous calculated colunm. > >Select t.*,t.RowId > >, CONTR_ROWS_MG - CONTR_ROWS_GROSS_RECEIVED >OutStanding >, CONTRACT_SALESAGENT_PERCENTAGE * >CONTR_ROWS_GROSS_RECEIVED / 100 AgentShare >,CONTRACT_SHARE_FIXED OtherShareFixed >,CONTRACT_SHARE_PERCENTAGE * >CONTR_ROWS_GROSS_RECEIVED /100 >OtherSharePercentage > >,AgentShare *2 > > > From Contract_Rows T,Contract > >Where Contract.Contract_Unique = >t.contr_rows_contract_unique > > >Thank you in advance > >Zsolt Csillag, >Hungary > >-- >Please see the official ORACLE-L FAQ: >http://www.orafaq.net >-- >Author: Zsolt Csillag > INET: [EMAIL PROTECTED] > >Fat City Network Services -- 858-538-5051 >http://www.fatcity.com >San Diego, California -- Mailing list and >web hosting services >To REMOVE yourself from this mailing list, send an >E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of >'ListGuru') and in >the message BODY, include a line containing: UNSUB >ORACLE-L >(or the name of mailing list you want to be removed >from). You may >also send the HELP command for other information >(like subscribing). >--------------------------------------------------- >------------------
Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).