RE: Math equation in Oracle SQL

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 
http://www.freelists.org/list/programmingblind

__________
View the list's information and change your settings at 
http://www.freelists.org/list/programmingblind

Other related posts: