17,086
社区成员
发帖
与我相关
我的任务
分享
MERGE INTO tjw_target_user a
USING (SELECT distinct bill_id FROM tjw_zly_1858_1122 ) b
ON (a.bill_id = b.bill_id )
WHEN MATCHED THEN UPDATE SET a.flag = 1
WHEN NOT MATCHED THEN INSERT (a.bill_id,a.flag)
VALUES (b.bill_id,1);
commit;