vwproducts.sql

< SQL Server2005程序设计>

CREATE VIEW vwProducts AS 
  SELECT Products.ProductID, Products.ProductName, Categories.CategoryName 
  FROM Products INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID