如何使用inner从select更新字段值？

Question

我正在尝试使用带有inner的select查询来更新mysql数据库中的字段值

我现在得到了

1064 -您的SQL语法中有一个错误；请查看与您的MySQL服务器版本对应的手册，以获得正确的语法，以便在第5行使用near 'AS cc WHERE cc.account_id = na.account_id‘。

UPDATE accounts AS na
SET na.pdm_id = (
SELECT cp.person_id FROM `temp_accounts` AS ta INNER JOIN call_managment_system.accounts AS a ON ta.company_code = a.company_code
INNER JOIN contact_personal AS cp ON cp.name = ta.FSM AND contact_link = 'PDM' 
) 
WHERE a.account_id = na.account_id

如何修复此查询才能正常工作？我想更新名为pdm_id的字段，将其设置为等于cp.person_id

谢谢

Answer 1

UPDATE  accounts na
INNER JOIN call_managment_system.accounts a
ON      a.account_id = na.account_id
INNER JOIN temp_accounts ta 
ON     ta.company_code = a.company_code
INNER JOIN contact_personal cp 
ON cp.name = ta.FSM        
SET     na.pdm_id = cp.person_id
WHERE   contact_link = 'PDM'