Hi All,
I am working with V7.2 fixpack 6 aix 4.3

update bs_attached t
set (inv_rate, market_value_amt,book_value_amt,last_upd_date,mark et_value_cur,book_value_cur,
last_upd_time,last_upd_zone)
= (select i.rate_, i.market_value,i.Book_Value,julian_day(i.As_Of_Dat e),1,1,86399,134480155
from tb_info i
where i.account_coid = t.account_coid
and i.invest_coid = t.ext_coid)
where t.account_coid = (select account_coid from tb_info i
where t.account_coid = i.account_coid
and invest_coid = ext_coid);

Thank you for your help