SQL ORACLE ORA-00969 : missing ON keyword?

Question

我有两个不同的表:Table_a 和 Table_b，两者都有相同的列 PartNo 和 Material_Desc。我希望当 PartNo 相等时，Table_b 中的 Material_Desc 更新 Table_a 中的 Material_Desc。这是我的查询

MERGE INTO Table_b 
USING ( SELECT t1.rowid AS rid
               , t2.Material_Desc
        FROM Table_b t1 
           JOIN Table_a t2 
           ON Table_b.PartNo = Table_a.PartNo ) 
ON rowid = rid 
WHEN MATCHED THEN 
    UPDATE 
    SET Table_a.Material_Desc = Table_b.Material_Desc;

我知道Oracle不支持更新语句的连接，所以我尝试了上面的查询。它仍然给我 ORACLE ORA-00969: 缺少 ON 关键字错误

Answer 1

您可以输入“(”和“)”。所以写:

ON ( rowid = rod )