1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
| CREATE OR REPLACE VIEW V_DAILY_OPEN AS
SELECT risk ,soci,sum(dpl_posit.mtm_pl) as cash,0 as future,0 as options,0 as inventorie,0 as freit,0 as forex
from dpl_posit
group by risk,soci
UNION
select risk,soci,0 as cash,sum(dpl_futures.mkt_price)as future,0 as options,0 as inventorie,0 as freit,0 as forex
from dpl_futures
group by risk,soci
union
select risk,soci,0 as cash,0 as future,sum(dpl_options.mkt_prime) as options,0 as inventorie,0 as freit,0 as forex
from dpl_options
group by risk,soci
union
select risk,soci ,0 as cash,0 as future,0 as options,sum(dpl_stock.mkt_price)as inventorie,0 as freit,0 as forex
from dpl_stock
group by risk,soci
union
select risk,soci,0 as cash,0 as future,0 as options,0 as inventorie,sum(dpl_fret.mkt_price) as freit,0 as forex
from dpl_fret
group by risk,soci
union
select risk,soci ,0 as cash,0 as future,0 as options,0 as inventorie,0 as freit,sum(dpl_forex.mkt_price)as forex
from dpl_forex
group by risk,soci |
