Syntax error? I beg to differ

[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?

[hapm]

There is a ) at the end of the query that doesn't belong there.

[blacksaibot]

Yeha that was a typo in the forum, it still doesnt work after removing it

[hapm]

Only a guess, as I think the SQL parser is a little bit picky here: set your query names between [] to escape them, or the parser tries to recognize them as numbers, because their names begin with a digit.