Select um Daten zu grupieren

[dataspider]

oder mit CTE:

Code:

with thelp as
       (select distinct
               t.regal
             , t.fach
             , iif(t.art like 'Grund%', 'Grund', iif(t.art like 'Erweiterung%', 'Erweiterung', '')) art
               from uetech_rebell t)
select t.regal
     , t.fach
     , (select list(thelp.art) from thelp where thelp.regal = t.regal and thelp.fach = t.fach)

 from
     (
        select distinct
               regal
             , fach
               from thelp
     ) t