Skip to Main Content

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!

Update using multiple conditions from multiple tables

861381May 17 2011 — edited May 17 2011
Hello,

I'm quite new to PL/SQL.

I need to update a record in a table using multiple conditions in the where clause from multiple tables.

On the internet I found something like

Update <table>
Set <column> = <value>
From <table>
Join <table>
on <condition>
Where <condition>
And <another condition>

Now i have:

update outbound_order
set outbound_order_sorting_code = 'A'
from orderref o, outbound_order oo
where oo.ordernumber = o.ordernumber
and o.delivery_status = 'c';

It gives Pl/SQL ORA00933 at -> from

Can't I use multiple tables in update?

Kind regards,

Chi Wai
This post has been answered by 860993 on May 17 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 14 2011
Added on May 17 2011
5 comments
7,468 views