SELECT haygroveMemberBusinessTravelCountryHotel.*,
  umbracoNode.text AS region
  FROM [haygroveMemberBusinessTravelCountryHotel]
  INNER JOIN umbracoNode ON umbracoNode.id = haygroveMemberBusinessTravelCountryHotel.CountryId
  WHERE [LevelId] IN ([[UMBRACO LEVEL ID]])