SQL MERGE 提示缺失values关键字
0
[已关闭问题]
关闭于 2019-12-27 16:54
MERGE INTO inaguc_t t1
USING (SELECT * FROM inaguc_t WHERE inagucent=60 AND inagucsite='M' AND inaguc001='3202010233' AND inaguc002='109' ) t2
ON (t1.inagucent = t2.inagucent AND t1.inagucsite=t2.inagucsite AND t1.inaguc001=t2.inaguc001 AND t1.inaguc002=t2.inaguc002 )
WHEN MATCHED THEN
UPDATE SET t1.inaguc003 = 100
WHEN NOT MATCHED THEN
INSERT (inagucent,inagucsite,inaguc001,inaguc002,inaguc003) VALUES (60,'M','3202010233','109',100);
执行提示缺失VALUES关键字，这是哪里错误？
