Site Header

SELECT *
FROM (
    SELECT *, euregReportingYear as siteReportingYear
    FROM [IED].[DB_VERSION].[Browse5_Header] as B5H
    LEFT JOIN [IED].[DB_VERSION].[site_flags] as SF
        ON B5H.[siteInspireId] = SF.[Site Inspire ID]
) as B5H