select crw.RWNAME as QUERYNAME, 
       CONCAT(crw.RWNAME,' - ',crw.RWVALUE) as QUERYTEXT,
       CONCAT(crw.RWNAME,' - ',crw.RWDESC,' - Gruppe: ',
       (select RWVALUE as GRPNAME from CCRW 
         where RWTYP='DQUERYPARAM' and RWPARENT=crw.RWNAME and RWNAME='group')) as QUERYDESC 
  from CCRW crw where RWTYP='DQUERY' and RWPARENT='QUERIES'
 order by crw.RWVALUE asc