内部联接update上的"SQL命令未正确结束“

Question

我到底在做什么错事？它给了我"SQL命令未正确结束“。

UPDATE RNP_PROF_ESP_CAT RPEC SET RPEC.RNP_ESPECIALIDADES_ID = 181
INNER JOIN RNP_PROF_ORDEM RPO ON RPO.RNP_PROF_IDENT_ID = RPEC.RNP_PROF_IDENT_ID 
WHERE RPO.N_CEDULA = '456258';

Answer 1

找到了答案：

UPDATE RNP_PROF_ESP_CAT RPEC SET RPEC.RNP_ESPECIALIDADES_ID = 181
WHERE EXISTS (SELECT 1 FROM RNP_PROF_ORDEM RPO WHERE RPO.N_CEDULA = '456258' AND RPO.RNP_PROF_IDENT_ID = RPEC.RNP_PROF_IDENT_ID);

Answer 2

UPDATE RPEC
SET RPEC.RNP_ESPECIALIDADES_ID = 181
FROM RNP_PROF_ESP_CAT RPEC
INNER JOIN RNP_PROF_ORDEM RPO ON RPO.RNP_PROF_IDENT_ID = RPEC.RNP_PROF_IDENT_ID 
WHERE RPO.N_CEDULA = '456258';