CDDA

SELECT * FROM (SELECT CAST(designated_site.cdda_id AS VARCHAR) site_code,
designated_site.site_name,
'CDDA' site_type,
country.country_name,
designated_site.cdda_region_code,
designated_site.designation_type_code,
designated_site.iucn_category,
designated_site.legal_foundation_year year_stablished,
designated_site.major_ecosystem_type,
designated_site.marine_area_percentage,
designated_site.national_id,
designated_site.ps_local_id,
designated_site.ps_namespace,
designated_site.ps_version_id,
designated_site.site_area area_ha,
designation_type.designation_type_code d2,
designation_type.designation_type_name cdda_designation_national_language,
designation_type.designation_type_name_english designation,
designation_type.national_designation_description description
FROM EUNIS.latest.Natda_designated_site designated_site,
EUNIS.latest.Natda_designation_type designation_type,
[BISE].[latest].[Country_Information] country
WHERE
designation_type.designation_type_code=designated_site.designation_type_code
AND country.country_code = designated_site.cdda_country_code
) as a