Oracle多表关联更新

错误的解法：

正确的解法：

UPDATE TABLE_ORDER O SET O.SETTLE_RATE = ( SELECT DISTINCT C.SETTLE_RATE FROM TABLE_ORDER, TABLE_CONFIG C WHERE O.PAY_ORG_ID = C.PAY_ORG_CODE ) WHERE ORDER_ID IN ( SELECT ORDER_ID FROM TABLE_ORDER WHERE STATUS = 2 AND ORDER_DATE BETWEEN ‘20160901’ AND ‘20160905’);

注意点：在子查询中通过对每条数据进行关联，因而不致于出现了单行子查询返回多个行