补充一下: select A.key1, A.key2 from A,B,C where A.key = B.key and A.key = C.key and B.key2 ='01' and C.del_flg ='00' and A.col1='00' 是动态SQL 文, 条件可变的。
update t_1 A set A.col1=‘01’ where ( A.key1, A.key2) in (select A.key1, A.key2 from A,B,C where ...)
key1和key2是联合主键吗? update A set col1='01' where exists(select 1 from B,C where A.key = B.key and A.key = C.key and B.key2 ='01' and C.del_flg ='00' and A.col1='00')
select A.key1, A.key2 from A,B,C where A.key = B.key and A.key = C.key and B.key2 ='01' and C.del_flg ='00' and A.col1='00'
是动态SQL 文, 条件可变的。
update A set col1='01'
where exists(select 1 from B,C where A.key = B.key and A.key = C.key and B.key2 ='01' and C.del_flg ='00' and A.col1='00')