select rol.ROLEID as "RollenID", 

       rol.ROLENAME as "Rollen-Name", 

       rol.ROLEDESC as "Beschreibung",

       CONCAT(IFNULL((select GROUP_CONCAT(distinct ua.GRP) from CCUSAS ua where ua.ROLE=rol.ROLEID),''),',',

              IFNULL((select GROUP_CONCAT(distinct uas.GRP) from CCUSAS uas where CONCAT(uas.GRP,'/',uas.ROLE)=rol.ROLEID),'')) 

          as "In Gruppen",

       '' as "Aktionen"

  from CCROLE rol