Update statement with a inner join
Need some SQL help here ....
I am trying to convert this statement to Oracle, but I am getting an error. The statement is ...
update carrier b
set b.company_key = a.company_key,
b.carrier_name = a.carrier_name,
b.carrier = a.carrier,
b.carrier_code = a.carrier_code,
b.delivery_days = a.delivery_days,
b.ship_method = a.ship_method
from preload_carrier a inner join carrier on
a.carrier_key = carrier.carrier_key;
The error I am getting is
SQL> @update_carrier.sql;
from preload_carrier a inner join carrier on
*
ERROR at line 8:
ORA-00933: SQL command not properly ended
In Oracle I understand there is no 'INNER JOIN'. Should I do a select statement within the update statement.
Your input is highly appreciated.
-Chintzs