select SUM(COUNT_OUT), SUM(COUNT_IN), SUM(SUMMA_D_OUT), SUM(SUMMA_D_IN), SUM(SUMMA_BL)
from
(
select
decode(1,COUNT_OUT,0) as COUNT_OUT,
decode(2,COUNT_OUT,0) as COUNT_IN,
decode(1,SUMMA_D_OUT,0) as SUMMA_D_OUT,
decode(2,SUMMA_D_OUT,0) as SUMMA_D_IN,
SUM(SUMMA_BL) as SUMMA_BL
from
(
select
1 as no,
count(t.dialed) as COUNT_OUT,
sum(t.duration) as SUMMA_D_OUT,
sum(t.in_balance_$) as SUMMA_BL
from
calls_all t
where
t.lcal_lcal_id = 39 and t.start_time>=:START_DATE and t.start_time<=to_date(:END_DATE)+1 and t.err_code is null
union all
select
2 as no,
count(t.dialed) as COUNT_OUT,
sum(t.duration) as SUMMA_D_OUT,
0 as SUMMA_BL
from
calls_all t
where t.lcal_lcal_id = 38 and t.start_time>=:START_DATE and t.start_time<=to_date(:END_DATE)+1 and t.err_code is null
) a
) b

select SUM(COUNT_OUT), SUM(COUNT_IN), SUM(SUMMA_D_OUT), SUM(SUMMA_D_IN), SUM(SUMMA_BL)
from
(
select
decode(COUNT_OUT,1,COUNT_OUT,0) as COUNT_OUT,
decode(COUNT_OUT,2,COUNT_OUT,0) as COUNT_IN,
decode(SUMMA_D_OUT,1,SUMMA_D_OUT,0) as SUMMA_D_OUT,
decode(SUMMA_D_OUT,2,SUMMA_D_OUT,0) as SUMMA_D_IN,
SUM(SUMMA_BL) as SUMMA_BL
from
(
select
1 as no,
count(t.dialed) as COUNT_OUT,
sum(t.duration) as SUMMA_D_OUT,
sum(t.in_balance_$) as SUMMA_BL
from
calls_all t
where
t.lcal_lcal_id = 39 and t.start_time>=:START_DATE and t.start_time<=to_date(:END_DATE)+1 and t.err_code is null
union all
select
2 as no,
count(t.dialed) as COUNT_OUT,
sum(t.duration) as SUMMA_D_OUT,
0 as SUMMA_BL
from
calls_all t
where t.lcal_lcal_id = 38 and t.start_time>=:START_DATE and t.start_time<=to_date(:END_DATE)+1 and t.err_code is null
) a
) b