Syntax error? I beg to differ (1 Viewer)

[blacksaibot]

Seriously, what in the hell is wrong with the syntax of this statement?

UPDATE 573_sae_data_new_aerpt
INNER JOIN 573_sae_data_new
ON 573_sae_data_new_aerpt.CSPCCID = 573_sae_data_new.CSPCCID
SET 573_sae_data_new_aerpt.AERPT = 573_sae_data_new.AERPT

Access gives the lovely error:
Syntax error in the query expression '573_sae_data_new_aerpt.CSPCCID = 573_sae_data_new.CPSCCI'.
Is there some stupid reason it's leaving off the "D" in CPSCCID at the end of this error message? Even if I screw around with my own query and type CSPCCIDxx it types it as "CPSCIDDx" in the error message.


What the hell is going on?

 

[pr2-eugin]

Cross posted @MSDN !

blacksaibot, please read : A message to forum cross posters.