oracle left join

 SELECT *
     FROM ( SELECT t1.account_period,arat.report_id, 
     sum(nvl(t1.call_times,0)) call_times, 
     sum(nvl(t1.call_duration,0)) call_duration, 
     sum(nvl(t1.stl_amount,0)) stl_amount, 
     sum(nvl(t2.call_times,0)) call_times_adjust, 
     sum(nvl(t2.call_duration,0)) call_duration_adjust, 
     sum(nvl(t2.stl_amount,0)) stl_amount_adjust 
     FROM (select account_period,long_code,account_sno, 
         sum(nvl(call_times,0)) call_times, 
         sum(nvl(call_duration,0)) call_duration, 
         sum(nvl(stl_amount,0)) stl_amount 
         from adt_blc_stat_t where account_period = ? 
    sql.addArg(vo.getAccount_period());
         AND kpi IN('10overtime','10per-her', 
             '10pur','10sms','10tietong') 
         group by account_period,long_code,account_sno) t1 
      LEFT JOIN (select account_period,long_code,account_sno, 
         sum(nvl(call_times,0)) call_times, 
         sum(nvl(call_duration,0)) call_duration, 
         sum(nvl(stl_amount,0)) stl_amount 
         from adt_blc_stat_t where account_period = ? 
    sql.addArg(vo.getAccount_period());
         AND kpi='adt_adjust' 
         group by account_period,long_code,account_sno) t2 
      ON t1.account_period=t2.account_period 
     AND t1.long_code=t2.long_code 
     AND t1.account_sno=t1.account_sno 
      LEFT JOIN adt_report_account_t arat 
      ON t1.account_sno=arat.account_sno 
     GROUP BY t1.account_period,arat.report_id ) abst 
      LEFT JOIN adt_report_t art 
      ON abst.report_id=art.report_id 
     LEFT JOIN adt_adjust_account_t aaat 
      ON abst.account_period=aaat.account_period 
     AND abst.report_id=aaat.report_id