update qzdxx_temp set qzdxx_temp.bgrq= (select b.max_bgrq
from v_yhda_temp b
where qzdxx_temp.hh=b.hh )
where qzdxx_temp.bgrq=to_date('2004-06-01','yyyy-mm-dd')
and qzdxx_temp.hh in (
select hh from v_yhda_temp
where max_bgrq>to_date('2004-06-30','yyyy-mm-dd') )
from v_yhda_temp b
where qzdxx_temp.hh=b.hh )
where qzdxx_temp.bgrq=to_date('2004-06-01','yyyy-mm-dd')
and qzdxx_temp.hh in (
select hh from v_yhda_temp
where max_bgrq>to_date('2004-06-30','yyyy-mm-dd') )
已经更新成功!!!