SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

missing SET keyword

520188Jan 31 2007 — edited Jan 31 2007

Hi folks, my sql is not the greatest yet so i would appreciate any help. i have a query....

UPDATE Species_list, species_lists, species_status
SET Species_list.list_id = 1, species_lists.status_id= species_status.status_id
WHERE su.list_id = 1 AND Species_list.ABERN_CONVENTION = species_status.status_code

the error i get is ORA-00971: missing SET keyword,. i think this is because you cant have multiple tables defined to update. Is this correct???

Also can anyone suggest a possible work sround for this, as i am more than confused in how to solve this problem!!

many thanks,
Rad

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 28 2007

Added on Jan 31 2007

11 comments

5,569 views