Site Header

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