oracle 兩張關聯表執行更新update

標籤：div   sele   and   sel   copy   rom   exist   oracle   date   

UPDATE T_ASN_DTL ad1 SET ad1.cf03=(    SELECT ac.TH003 FROM "T_ASN_DTL_copy" ac WHERE ac.udf06=ad1.INSPECTER_NAME and ac.udf05=ad1.LINE_ITEM_NO) WHERE EXISTS (SELECT 1 FROM "T_ASN_DTL_copy"  ac WHERE ac.udf06=ad1.INSPECTER_NAME and ac.udf05=ad1.LINE_ITEM_NO)UPDATE 表2  SET 表2.C =     (SELECT B       FROM 表1      WHERE 表1.A = 表2.A) WHERE EXISTS     (SELECT 1       FROM 表1      WHERE 表1.A = 表2.A);      

 

oracle 兩張關聯表執行更新update