Home » SQL & PL/SQL » SQL & PL/SQL » Updating a column based on two other tables
Updating a column based on two other tables [message #256602] Mon, 06 August 2007 01:54 Go to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
UPDATE master.ref_case_mgmt_provider SET
      case_mgmt_provider_name = v_new_cm_name
     WHERE commercial_prod.member_master.payor_id = gv_payor_id
     AND   commercial_prod.member_master.center_id = gv_center_id
     AND   commercial_prod.member_master.stnd_member_id = pin_cups_member_id
     AND   commercial_prod.member_master.stnd_member_id = commercial_prod.member_case_management.stnd_member_id 
     AND   commercial_prod.member_master.process_group_id = commercial_prod.member_case_management.process_group_id
     AND   commercial_prod.member_case_management.stnd_case_mgmt_provider_code =  master.ref_case_mgmt_provider.stnd_case_mgmt_provider_code;



Is it possible to update like this?else any pointers to go about it would be helpful.

Thanks
Re: Updating a column based on two other tables [message #256610 is a reply to message #256602] Mon, 06 August 2007 02:07 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Search in this forum with the following keyword
"updating a table from another table". Choose the thread which will be of interest you.
Re: Updating a column based on two other tables [message #256630 is a reply to message #256610] Mon, 06 August 2007 02:51 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
Hi i am not able to find the exact solution for my requirement,could someone pls guide?
Re: Updating a column based on two other tables [message #256634 is a reply to message #256630] Mon, 06 August 2007 03:17 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search again, the answer is there.

Regards
Michel
Previous Topic: class oracle/CDC/PublishApi does not exist
Next Topic: ORA-12518
Goto Forum:
  


Current Time: Sat Dec 10 05:25:43 CST 2016

Total time taken to generate the page: 0.05587 seconds