Update statement with inner join on Oracle

871 Asked by EstebanOsterberg in SQL Server , Asked on Jun 20, 2021

I have a query which works fine in MySQL, but when I run it on Oracle I 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';

How oracle update with join ?

Your Answer