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).
- SQL PROBLEM Harvinder Singh
- Re: SQL PROBLEM Diana_Duncan
- RE: SQL PROBLEM Niyi Olajide
- RE: SQL PROBLEM Mohan, Karthik (GEP)
- RE: Sql problem Zsolt Csillag
- RE: Sql problem Stephane Faroult
- RE: Sql problem Khedr, Waleed
- Re: Sql problem Tim Gorman
- Re: Sql problem Zsolt Csillag