网上对于不同表的merge into的用法很多，可以搜索参考点击
示例代码
根据T_BUSINESS_STATISTICS表的字段station_org_no和字段business_date进行有则更新无则插入
merge into T_BUSINESS_STATISTICS A USING (select '212122222222222' station_org_no,'2021-06-06' business_date from dual ) C
ON(A.station_org_no=C.station_org_no and A.business_date=C.business_date)
when matched then
update SET A.province_org_no='testoo1qqqqxxxxx'
when not matched then
insert(A.id,A.province_org_no,A.station_org_no,A.business_date,CREATED_BY,updated_BY,status) values(212199921,'neworg','212122222222222','2021-06-06',-1,-1,1);
注意：如果有传入或者查询出的连接条件（station_org_no或者business_date）为null，则更新，
A.station_org_no=C.station_org_no and A.business_date=C.business_date
