ORDER DETAILS

CREATE VIEW [dbo].[vOrder Details]

AS

SELECT [Order Details].*, Products.ProductName, Orders.OrderDate

FROM [Order Details]

INNER JOIN Orders ON Orders.OrderID = [Order Details].OrderID

INNER JOIN Products ON Products.ProductID = [Order Details].ProductID

GO

The “vOrder Details” view is used to pull the ProductName for the browse mode below