select rwq.RWNAME, rwq.RWVALUE, rwq.RWDESC

  from CCRW rwq

    left outer join CCRW qg on qg.RWTYP='DQUERYPARAM' and qg.RWPARENT=rwq.RWNAME and qg.RWNAME='group'

 where qg.RWVALUE='SVCLMeldStatData'

UNION

 select SUBSTR(mf.MFILEID,13),mf.MFILEID,mf.MFILEATTRIBS

   from CCMFILES mf

 where mf.MFILETYPE='dquerymfile' and SUBSTR(mf.mfileid,13,14)='SVCLRFSTATMeld'