update table1 a set a.WTAMT1=(select 0 from table2 where a.id=b.id) where a.id in (select id from table2 t where t.col1='aa' and t.col2='bb')
Oracle updata join 多表关联更新
最新推荐文章于 2024-08-29 20:34:03 发布
update table1 a set a.WTAMT1=(select 0 from table2 where a.id=b.id) where a.id in (select id from table2 t where t.col1='aa' and t.col2='bb')