Oracle - Update statement with inner join
Posted
by user169743
on Stack Overflow
See other posts from Stack Overflow
or by user169743
Published on 2010-03-15T11:40:21Z
Indexed on
2010/03/15
11:59 UTC
Read the original article
Hit count: 730
Oracle
|inner-join
I have a query which works fine in MySQL, I'm trying to get it working on oracle but get the following error
SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended"
The query is:
UPDATE table1
INNER JOIN table2
ON table1.value = table2.DESC
SET table1.value = table2.CODE
WHERE table1.UPDATETYPE='blah';
I'd be extremely grateful for any help.
© Stack Overflow or respective owner