Merge clause with inner join

MERGE table1
USING (SELECT table3.keycolumn,
              table2.DataColumn1,
              table2.DataColumn2
       FROM table2
       INNER JOIN table3
           ON table2.anotherKey = table3.anotherKey
       WHERE table2.anotherKey = 'A1') tmpTable
ON 
   table1.keyColumn = tmpTable.keyColumn
WHEN MATCHED THEN
       UPDATE
       SET table1.DataColumn1 = tmpTable.DataColumn1
            ,table1.DataColumn2 = tmpTable.DataColumn2;

Source: stackoverflow.com

Similar codes

9 votes608 views2 answers
Current date in postgresql minus 1 day
SQL
5 votes309 views1 answer
Postgres upsert
SQL
4 votes337 views2 answers
Oracle unliock account
SQL
0 vote370 views1 answer
Mysql uuid
SQL
0 vote417 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote372 views1 answer
Sql date time query find
SQL
0 vote345 views1 answer
Soql user profile
SQL
0 vote353 views1 answer
Phpmyadmin tabellentyp ändern
SQL
2 votes369 views1 answer
Mysql select default if null
SQL
0 vote349 views1 answer
Except in sql
SQL