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')
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')