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