Oracle error message

From: "Eileen Lafond" <Eileen.Lafond@xxxxxxxxxxx>
To: <programmingblind@xxxxxxxxxxxxx>
Date: Wed, 20 Aug 2008 10:43:49 -0700

Hi,
I have an Oracle error message in my code that I cannot figure out how to 
resolve.  

I am placing the code here and if anyone has any suggestions, please let me 
know:

 
 UPDATE RP08_R2_EMPL_TBL rp1
  2  SET rp1.TOTAL_PRECOLA_PAID =
  3  (SELECT SUM(rp2.resource_amount) FROM rp08_r2_retro_pay_sum rp2
  4  WHERE rp2.eliminate_status = 'Y'
  5  GROUP BY rp2.emplid)
  6  WHERE RP1.EMPLID = RP2.EMPLID
  7  /
WHERE RP1.EMPLID = RP2.EMPLID
                   *
ERROR at line 6:
ORA-00904: "RP2"."EMPLID": invalid identifier 


 
 commit;

Commit complete.

 
 spool off


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

Follow-Ups:
- RE: Oracle error message
  - From: Good, John
- RE: Oracle error message
  - From: Adrian Beech

References:
- PHP - What Comes With A PHP Script Automatically?
  - From: james . homme

Oracle error message

Other related posts: