sql - SQL 命令未正确结束错误；尝试使用连接更新信息

Question

UPDATE A
SET A.email_from = B.new_email_from
FROM email_list A 
INNER JOIN update B 
    ON A.email_subject = B.email_subject 
WHERE A.process = B.process;

我正在尝试使用另一个表包含的更新信息来更新一个表。我不确定为什么它一直给我这个错误。

ORA-00933: SQL command not properly ended

标签： sqloracle

Answer 1

一个简单的MERGE就行

MERGE INTO a 
USING b 
ON ( a.email_subject = b.email_subject ) 
WHEN matched THEN 
  UPDATE SET a.email_from = b.new_email_from 
WHERE a.process = b.process;