merge into pm_vendor_item_relation_def_t a using (select company_code, vendor_code,item_code,item_name,vendor_name from srm_vendor_credit) b
on (a.company_code = b.company_code
and a.vendor_code = b.vendor_code
and a.item_code = b.item_code)
when matched then
update set a.vendor_name = b.vendor_name,a.item_name=b.item_name;
when not matched then
insert--(a.company_code, a.vendor_code,a.item_code,a.item_name,a.vendor_name)
values(b.company_code, b.vendor_code,b.item_code,b.item_name,b.vendor_name); 该语句一直提示‘缺少关键字’
不止如何是好
求助
其中,pm_vendor_item_relation_def_t和srm_vendor_credit表的键值均为company_code, vendor_code,item_code。
on (a.company_code = b.company_code
and a.vendor_code = b.vendor_code
and a.item_code = b.item_code)
when matched then
update set a.vendor_name = b.vendor_name,a.item_name=b.item_name;
when not matched then
insert--(a.company_code, a.vendor_code,a.item_code,a.item_name,a.vendor_name)
values(b.company_code, b.vendor_code,b.item_code,b.item_name,b.vendor_name); 该语句一直提示‘缺少关键字’
不止如何是好
求助
其中,pm_vendor_item_relation_def_t和srm_vendor_credit表的键值均为company_code, vendor_code,item_code。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货