简单问题就给我们这些菜鸟回答吧,让我们也加点分啊:)
第一个 视图
CREATE VIEW dbo.VIEW1
AS
SELECT a.*
FROM dbo.Orders a INNER JOIN
dbo.[Order Details] b ON a.OrderID = b.OrderID
WHERE (b.UnitPrice > 50)
第二个 视图
CREATE VIEW dbo.VIEW2
AS
SELECT ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit
FROM dbo.Products