vwsuppliers.sql

来自「< SQL Server2005程序设计>」· SQL 代码 · 共 6 行

CREATE VIEW dbo.vwSuppliers
AS
SELECT Products.ProductID, Products.ProductName, 
    Suppliers.CompanyName AS SupplierName
FROM Products INNER JOIN
    Suppliers ON Products.SupplierID = Suppliers.SupplierID