DB2数据库视图的创建

create view jzhq_view
(lipperid, cname, AREATYPE,date,Unit_Net_Value,
growth_1d,growth_1w,growth_1m, growth_3m ,growth_6m,growth_1y,growth_jn,growth_bg,
StdDev_1y,Sharpe_1y,Bonus2_bg)
as
select  lm.lipperid , lm.cname, lm.AREATYPE,lm.nav_Date,lm.nav,
lip1d.growth,
lip1w.growth,lip1m.growth, lip3m.growth ,lip6m.growth,lip1y.growth,lipjn.growth,lipbg.growth,
lip1y.StdDev,lip1y.Sharpe,lipbg.Bonus2 
from lipperm lm
left join (select lipperid, growth from lippervalue where datarange='1d') as lip1d on lm.lipperid=lip1d.lipperid--//最新增长率
left join (select lipperid, growth from lippervalue where datarange='1W') as lip1w on lm.lipperid=lip1w.lipperid--//一星期
left join (select lipperid, growth from lippervalue where datarange='1M') as lip1m on lm.lipperid=lip1m.lipperid--//一月
left join (select lipperid, growth from lippervalue where datarange='3M') as lip3m on lm.lipperid=lip3m.lipperid--//3个月
left join (select lipperid, growth from lippervalue where datarange='6M') as lip6m on lm.lipperid=lip6m.lipperid--//6个月
left join (select lipperid,StdDev,Sharpe,growth from lippervalue where datarange='1Y') as lip1y on lm.lipperid=lip1y.lipperid--//一年
left join (select lipperid, growth from lippervalue where datarange='2007') as lipjn on lm.lipperid=lipjn.lipperid--//今年以来
left join (select lipperid, growth,Bonus2 from lippervalue where datarange='BG') as lipbg on lm.lipperid=lipbg.lipperid--//开始以来