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

2 votes273 views1 answer
Sql view column data type
SQL
2 votes329 views1 answer
Oracle apex list connected users
SQL
5 votes336 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
0 vote335 views1 answer
Python list from sql
SQL
3 votes317 views1 answer
Oracle apex warn on unsaved changes
SQL
0 vote332 views2 answers
How covert into int in maria db
SQL
0 vote363 views1 answer
Check if mysql db is used
SQL
1 vote317 views1 answer
Sql server locks
SQL
14 votes341 views3 answers
Delete all records from table except sql
SQL
0 vote306 views1 answer
Mssql describe stored procedure sqlcmd
SQL