Site environmental information

SELECT B6H.authAddress,
    B6H.authLastUpdated,
    B6H.contactMail,
    B6H.contactPerson,
    B6H.countryCode,
    B7H.CountryName as countryName,
    B6H.eprtrReportingDate,
    B6H.eprtrReportingYear,
    B6H.euregReportingYear,
    B6H.facilityInspireId,
    B6H.facilityMainActivity,
    B6H.mainActivity,
    B6H.nationalId,
    B6H.NUTS,
    B6H.organizationName,
    B6H.regulation,
    B6H.riverBasin,
    B6H.shape_wm_as_text,
    B6H.siteInspireId,
    B6H.siteName,
    B7H.facilityAddress,
    B7H.facilityContactMail,
    B7H.facilityContactPerson,
    B7H.facilityIndustrialActivity,
    B7H.facilityName,
    B7H.facilityOrganizationName
FROM [IED].[latest].[Browse6Header] as B6H
LEFT JOIN [IED].[latest].[Browse7Header] as B7H
ON
    B6H.siteInspireId = B7H.siteInspireId
    AND B6H.facilityInspireId = B7H.facilityInspireId
    AND B6H.euregReportingYear = B7H.euregReportingYear
    AND B6H.organizationName = B7H.facilityOrganizationName

No data