Site structure

SELECT facilities.siteName,
    facilities.siteInspireId,
    facilities.facilityInspireId,
    installations.installationInspireId,
    lcps.lcpInspireId
FROM [IED].[DB_VERSION].[Browse6Header] as facilities
LEFT JOIN [IED].[DB_VERSION].[Browse8Header] as installations
    ON facilities.facilityInspireId = installations.facilityInspireId
    AND facilities.euregReportingYear = installations.euregReportingYear
LEFT JOIN [IED].[DB_VERSION].[Browse10_Header] as lcps
    ON installations.installationInspireId = lcps.installationInspireId
    AND installations.euregReportingYear = lcps.euregReportingYear
GROUP BY facilities.siteName,
    facilities.siteInspireId,
    facilities.facilityInspireId,
    installations.installationInspireId,
    lcps.lcpInspireId