sql - SQL，更新命令未正确结束

Question

它一直说：ORA-00933：SQL 命令未正确结束

请帮助我或给我一个解决方案的链接

UPDATE emprunts
SET etat = 'RE'
FROM emprunts A
JOIN detailsemprunts B
    ON A.numero = B.emprunt
WHERE B.rendule is not null;```

标签： sqloracle

Answer 1

您可以改用相关子查询：

update emprunts e
set etat = 'etat'
where exists (
    select 1 
    from detailsemprunts de 
    where e.numero = de.emprunts and de.rendule is not null
)