I have to ask you because I havn't a good solution for this.
I have table F0901 with key fields: GMMCU, GMOBJ and GMSUB and one field GMR015 which I would like to update.
The source table is FUPD02 with key fields: UPMCU, UPOBJ and UPSUB and source_update field UPR015.
I check many source but always have some errors; my latest statements is:
UPDATE F0901 SET GMR015 = (SELECT UPR015 FROM FUPD02 WHERE GMMCU!!GMOBJ!!GMSUB=UPMCU!!UPOBJ!!UPSUB) WHERE EXIST (SELECT UPMCU!!UPOBJ!!UPSUB FROM FUPD02 WHERE GMMCU!!GMOBJ!!GMSUB=UPMCU!!UPOBJ!!UPSUB)
Have you idea how to change this statement?