select v.acc_end_val,
v.acc_end_val* (select value
from (select date_price, value, code from table1.t_fi f, table1.t_fi_price p, table1.v_lic_acc_value v where f.id=p.link_fi and v.fi_code=f.code and date_price<'02.05.2010'
order by date_price desc) where rownum=1 and v.fi_code=code) as stoimost
from table1.v_lic_acc_value v,table1.t_fi f, table1.t_list_fi_type t
where
v.date_cal_from = to_date('01.05.2010' , 'dd.mm.yyyy')
and v.date_cal_to = to_date('01.05.2010' , 'dd.mm.yyyy')
and v.acc_end_val!='0'
and v.depo_acc_num='MS9403170488'
and v.section_type_name='Основной'
and v.fi_code=f.code
and f.link_fi_type=t.id
and t.id='100142574';
Рез-тат:
v.acc_end_val |STOIMOST
501 |601781.16
30422820 |49174533563.4
10200000 |0
|
