1、通过子查询关联更新多字段
update service cs set (cs.customer_id,cs.customer_code,cs.customer_name)=
(
select ccb.customer_id,ccb.customer_code,ccb.customer_name from customer_base ccb
inner join customer_contact ccc
on ccb.customer_id=ccc.customer_id
where ccc.key_='1' and ccc.value_=cs.value_ and rownum<2
)
where customer_id='0' and start_time>sysdate-30