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