pivot, Oracle - rextester

Language: Layout:

with table1 as (select 2016 id, 1 kost_id, 'bla' col1 from dual union all
                select 2016, 2, 'bla'  from dual union all
                select 2016, 3, 'bla1' from dual union all
                select 2016, 4, 'abl'  from dual union all
                select 2016, 5, null   from dual union all
                select 2016, 6, null   from dual union all
                select 2016, 7, null   from dual union all
                select 2017, 2, null   from dual union all
                select 2017, 3, null   from dual),
     table2 as (select 2016 id, 1 kost_id, 1 mw_id, 10 euro from dual union all
                select 2016, 2, 2, 20  from dual union all
                select 2016, 3, 6, 30  from dual union all
                select 2016, 3, 5, 40  from dual union all
                select 2016, 5, 5, 50  from dual union all
                select 2016, 6, 6, 60  from dual union all
                select 2016, 7, 3, 70  from dual union all
                select 2016, 4, 4, 80  from dual)
select * 
  from table1 join table2 using (id, kost_id)
  pivot (sum(euro) for mw_id in (1 mw1, 2 mw2, 3 mw3, 4 mw4, 5 mw5, 6 mw6))
  order by id


absolute service time: 0,92 sec