Skip to Content
0
Jun 25, 2007 at 07:54 AM

How do I use an INNER JOIN in an UPDATE query?

1271 Views

In standard SQL I can run the following update:

UPDATE zrm_fy_upload INNER JOIN ZRM_FY_V_CAS_ATT

ON zrm_fy_upload-ZZACCID = ZRM_FY_V_CAS_ATT-ZZACCID

SET ZRM_FY_V_CAS_ATT-ZZSPRAS = zrm_fy_upload-ZZSPRAS.

commit work.

In ABAP, I get a compile error - "INNER JOIN.. ON not expected".

Can someone tell me how I should write my update so it works in ABAP?

Thank you,

Olivier