Update set with inner join oracle

UPDATE 
(SELECT table1.value as OLD, table2.CODE as NEW
 FROM table1
 INNER JOIN table2
 ON table1.value = table2.DESC
 WHERE table1.UPDATETYPE='blah'
) t
SET t.OLD = t.NEW

or

UPDATE table1 SET table1.value = (SELECT table2.CODE
                                  FROM table2 
                                  WHERE table1.value = table2.DESC)
WHERE table1.UPDATETYPE='blah'
AND EXISTS (SELECT table2.CODE
            FROM table2 
            WHERE table1.value = table2.DESC);

Source: stackoverflow.com

Similar codes

0 vote146 views1 answer
Setval postgres example table id
SQL
34 votes169 views6 answers
Install mysql client ubuntu
SQL
0 vote147 views1 answer
Sqlite insert or update
SQL
0 vote225 views1 answer
Which MySQL data type to use for storing boolean values
SQL
8 votes138 views4 answers
Mysql update one table from another table multiple columns
SQL
15 votes171 views4 answers
Mysql export database command line
SQL
0 vote134 views1 answer
How to count with except in psql
SQL
0 vote142 views1 answer
Power bi union columns
SQL
3 votes132 views1 answer
How to remove characters from string in mysql
SQL
3 votes146 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL