select distinct ENV as VALUE, ENV as TEXT, 'Umgebung ' || ENV as DESCRIPTION from CCDCHOST
union all
select distinct PARENT as VALUE, PARENT as TEXT, 'Umgebungsgruppe ' || PARENT as DESCRIPTION from CCDCENV