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

1 vote201 views1 answer
Retrieve meaning
SQL
0 vote214 views1 answer
How convert into in in sql query
SQL
0 vote188 views1 answer
Case insensitive sql
SQL
0 vote182 views1 answer
Order by monthly in sql
SQL
0 vote195 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote196 views3 answers
Group_concat sql server
SQL
4 votes194 views1 answer
Group by mysql and concatenate string
SQL
1 vote178 views1 answer
Set id count mysql
SQL
0 vote196 views1 answer
Postgresql not in alternative
SQL
0 vote201 views1 answer
Oracle calculate statistics on partition
SQL