RE: Math equation in Oracle SQL
- From: "Pranav Lal" <pranav.lal@xxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Sat, 23 Aug 2008 18:30:15 +0530
Are you sure that rp2 is a table name?
-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Eileen Lafond
Sent: Saturday, August 23, 2008 3:51 AM
To: programmingblind@xxxxxxxxxxxxx
Subject: Math equation in Oracle SQL
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
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
