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

Filed under:
|

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

Related posts about Oracle

Related posts about inner-join