#ora-00933

Fixed: Oracle – Update statement with inner join #answer #solution #programming

Oracle – Update statement with 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…