Листинг 3

CREATE VIEW EastTerr AS
SELECT Territories.TerritoryDescription,
  Region.RegionDescription
FROM Territories INNER JOIN
  Region ON Territories.RegionID = Region.RegionID
WHERE Territories.RegionID = 1