Sometimes we have a scenario where all the data that needs to be updated in TABLE1 is available in a different table TABLE2.
Here the situation is that we have more than one column to be updated in TABLE1 from TABLE2.
Your UPDATE query looks like below.
UPDATE TABLE1 A SET (COL11, COL12, COL13) = ( SELECT COL21, COL22, COL23 FROM TABLE2 B WHERE B.COL20 = A.COL10 ) WHERE COL14 = 'A' AND COL15 = 123 ;
Note: You need to ensure that the TABLE2 retrieves only one row with the condition used to check from it. (WHERE B.COL20 = A.COL10)
In United States, If you would like to Earn Free Stocks, Credit card Points and Bank account Bonuses, Please visit My Finance Blog
You may also like to look at: