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

15 votes365 views5 answers
Show tables in oracle
SQL
0 vote377 views1 answer
Sql today at midnight
SQL
1 vote365 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote399 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
4 votes352 views3 answers
NOT NULL SQL
SQL
0 vote355 views1 answer
Install sql server windows 10
SQL
0 vote376 views2 answers
Drop tables from local table database postgres
SQL
0 vote365 views3 answers
Query string not ending with with vowels
SQL
1 vote355 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
10 votes362 views5 answers
Between keyword in sql
SQL