select distinct ENV as VALUE, ENV as TEXT,CONCAT( 'Umgebung ' ,ENV) as DESCRIPTION from CCDCHOST

union all

select distinct PARENT as VALUE, PARENT as TEXT, CONCAT('Umgebungsgruppe ' ,PARENT) as DESCRIPTION from CCDCENV