SELECT * 
FROM HCMTemplates 
INNER JOIN Status ON HCMTemplates.TemplateStatus=Status.Id 
INNER JOIN Country ON HCMTemplates.AssignToCountry=Country.code
Where HCMTemplates.TemplateName like '