mainframe - Is there any way update using join in db2

Question

UPDATE TB1 TB
SET TB.DEBITED_AMT = TB.CHECK_AMOUNT
WHERE EXISTS
(
SELECT MASTER_ID
FROM TR1 TR
where TR.COATER_CODE = '010'
AND TR.MASTER_ID = '989778888'
AND TR.TRX_CODE = 'AB'
AND TR.DIS_IND ='S'
);

I Used this code but only tb1 row fetched but not synced with tr2...master_id is prmary_key here

question from:https://stackoverflow.com/questions/66064235/is-there-any-way-update-using-join-in-db2

Answer 1

Waitting for answers