Installation BAT Conclusions

SELECT conclusion.*,
    derogation.BATAELName as derogationBATAELName,
    derogation.StartDate as derogationStartDate,
    derogation.EndDate as derogationEndDate,
    derogation.PublicReason as derogationPublicReason,
    derogation.Status as derogationStatus
FROM [IED].[DB_VERSION].[Browse9Header_BATConclusion] as conclusion
LEFT OUTER JOIN [IED].[DB_VERSION].[Browse9Header_BATDerogation] as derogation
ON 
    derogation.BATAELName LIKE '%' + conclusion.BATConclusionName + '%'
    AND derogation.installationInspireId = conclusion.installationInspireId
    AND derogation.EUregReportingYear = conclusion.EUregReportingYear