Листинг 2

SELECT Territories.TerritoryDescription,
  Region.RegionDescription
 FROM Territories INNER JOIN
  Region ON Territories.RegionID = Region.RegionID
 WHERE Territories.RegionID = 1