ORACLE UPDATE 多表关联的update语句
-- update 超过2个值
update customers a -- 使用别名
set (city_name,customer_type)=(select b.city_name,b.customer_type
from tmp_cust_city b
where b.customer_id=a.customer_id)
where exists (select 1
from tmp_cust_city b
where b.customer_id=a.customer_id
)
update mafedb.t_cqcs_batchinfo a set a.trandate=(select trandate from mafedb.t_cqcs_qryctlreq b where a.batchno=b.batchno and rownum=1 ) where a.trandate<=20180920