CREATE View [1MOrders] AS
SELECT TOP 1000000
[Orders].[OrderID]
,[CustomerID]
,[OrderDate]
,[RequiredDate]
,[ShippedDate]
,[ShipVia]
,[Freight]
,[ShipName]
,[ShipAddress]
,[ShipCity]
,[ShipRegion]
,[ShipPostalCode]
,[ShipCountry]
,[Order Details].[UnitPrice]
,[Quantity]
,[Discount]
,[Products].[ProductID]
,[ProductName]
,[QuantityPerUnit]
,[UnitsInStock]
,[UnitsOnOrder]
,[ReorderLevel]
,[Discontinued]
,[CategoryName]
,[Description]
FROM Orders
JOIN [Order Details] ON [Order Details].[OrderID] = [Orders].[OrderID]
CROSS JOIN Products
CROSS JOIN Categories
GO