select
a.year,
a.month,
b.netid,
nvl(c.value,0) as value,
nvl(c.price,0) as price
from
(select distinct year,month from ta) a,
tb b,
ta c
where
a.year=b.year(+) and a.month=b.month(+) and b.netid=c.netid(+)
order by
a.year,a.month,b.netid
a.year,
a.month,
b.netid,
nvl(c.value,0) as value,
nvl(c.price,0) as price
from
(select distinct year,month from ta) a,
tb b,
ta c
where
a.year=b.year(+) and a.month=b.month(+) and b.netid=c.netid(+)
order by
a.year,a.month,b.netid
a.year,
a.month,
b.netid,
nvl(c.value,0) as value,
nvl(c.price,0) as price
from
(select distinct year,month from ta) a,
tb b,
ta c
where
a.year=c.year(+) and a.month=c.month(+) and b.netid=c.netid(+)
order by
a.year,a.month,b.netid