Форум программистов [Powered by Invision Power Board]

Код

SQL> with d_e as(
  2   select 1 id,378    id_d,25    id_e from dual
  3   union all select 2,    378,    26 from dual
  4   union all select 3,    379,    27 from dual
  5   union all select 4,    380,    28 from dual
  6   union all select 5,    380,    29 from dual
  7   union all select 6,    380,    30 from dual
  8  )
  9  ,d_e_prop as(
 10   select 25 id_e,    372 id_prop,   '28.02.2009' value from dual
 11   union all select 25,    380,    '5000' from dual
 12   union all select 25,    385,    'text' from dual
 13   union all select 26,    372,    '25.02.2009' from dual
 14   union all select 26,    380,    '2000' from dual
 15   union all select 27,    372,    '20.03.2009' from dual
 16   union all select 27,    380,    '' from dual
 17   union all select 27,    385,    'text2' from dual
 18  )
 19  select id_d
 20         ,max(case when id_prop=372 then value end) "value(1)"
 21         ,max(case when id_prop=380 then value end) "value(2)"
 22         ,max(case when id_prop=385 then value end) "value(3)"
 23  from d_e left join d_e_prop on d_e.id_e = d_e_prop.id_e
 24  group by id_d
 25  ;
 
      ID_D value(1)   value(2)   value(3)
---------- ---------- ---------- ----------
       380                       
       378 28.02.2009 5000       text
       379 20.03.2009            text2
 
SQL>