Update using multiple conditions from multiple tables
861381May 17 2011 — edited May 17 2011Hello,
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