Math equation in Oracle SQL
- From: "Eileen Lafond" <Eileen.Lafond@xxxxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Fri, 22 Aug 2008 15:20:42 -0700
I have to divide two fields and put the result in another field. I am just
starting out with the select statement of the equation itself, but am getting a
strange error message. I am putting the code and error mesage here, if
someone can assist me.
select (rp2.RESOURCE_AMOUNT / rp1.TOTAL_PRECOLA_PAID) from
RP08_R2_RETRO_PAY_SUM r2, rp08_r2_empl
*
ERROR at line 1:
ORA-00904: "RP2"."RESOURCE_AMOUNT": invalid identifier
SQL>
SQL>
Thanks for any help,
Eileen La Fond
Phone (206) 386-0011
e.mail Eileen.LaFond@xxxxxxxxxxx
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
