17,090
社区成员
发帖
与我相关
我的任务
分享
merge into table_a v
using
(
select t1,t2,t3 from table_b,TABLE_C where …
) res on(v.t1=b.t1)
when matched then
update set v.f1=zny.t2,
v.f2=zny.t3,
when not matched then
insert v (f1,f2)value(t2,t3)
table_a
f1 T1
北京3962 65601
res
t2 T1
北京3962 10732
MERGE INTO T1 USING T2 ON(T1.ID=T2.ID)
WHEN MATCHED THEN
UPDATE SET T1.NM='US' WHERE T1.ID=2;
res on(v.t1=b.t1 or v.f1=b.t2)
when matched then
update set v.f1=zny.t2,
v.f2=zny.t3,
v.t1=b.t1