Hello

The following sentence does not run, is there an alternative way to achieve and Update using an Inner Join?

Thanks a lot.

update ECFORCLI.FCSTAAAA
set
FCU01A = ECFORCLI.FCSTAAAATM.FCU01A
from ECFORCLI.FCSTAAAA
inner join ECFORCLI.FCSTAAAATM on
ECFORCLI.FCSTAAAATM.FCANO = ECFORCLI.FCSTAAAA.FCANO and
ECFORCLI.FCSTAAAATM.FCSTOC = ECFORCLI.FCSTAAAA.FCSTOC

Hi,

update ECFORCLI.FCSTAAAA
set
FCU01A = ECFORCLI.FCSTAAAATM.FCU01A
from ECFORCLI.FCSTAAAA AS T1
where
(ECFORCLI.FCSTAAAATM.FCANO, ECFORCLI.FCSTAAAATM.FCSTOC)
in
(
select ECFORCLI.FCSTAAAA.FCSTOC, ECFORCLI.FCSTAAAA.FCANO from ECFORCLI.FCSTAAAA where
T1.FCANO = ECFORCLI.FCSTAAAA.FCANO and
T1.FCSTOC = ECFORCLI.FCSTAAAA.FCSTOC
)

I hope I didn't mistype table names. Please in the future use more simple names for example on forum.

Hope this helps,
Grofaty