基于内部联接oracle sql插入(Insert based on inner join oracle sql)

 我有一张表A，其中有三列ab c。 我想基于列c与另一个表B的连接将值插入到列a和b中 
 
 我使用以下查询 
 
MERGE INTO A
USING
(SELECT * FROM B) **B**
ON (B.c=A.c)
WHEN MATCHED THEN
INSERT(a,b) VALUES(local_varialble,'STRING');
 
 我收到以下错误 
 
PL/SQL : ORA-00905 : MISSING KEYWORD
 
 请帮忙 ！！ 这个查询似乎总是很棘手 
 
 编辑：我发现在ON条件下使用！=并且在WHEN NOT MATCHED完成编译后完成编译...但我不知道它是否会产生正确的结果 

I have a table A with three columns a b c. I want to insert values in to columns a and b based on the join of column c with another table B
 
I am using the following query 
 
MERGE INTO A
USING
(SELECT * FROM B) **B**
ON (B.c=A.c)
WHEN MATCHED THEN
INSERT(a,b) VALUES(local_varialble,'STRING');
 
I am getting the following error
 
PL/SQL : ORA-00905 : MISSING KEYWORD
 
Please help !! This query always seems to be tricky 
 
EDIT : I found out that using != in the ON condition and following it up with WHEN NOT MATCHED compiles perfectly.. but I don't know whether it yields the correct result 

原文：https://stackoverflow.com/questions/19793143