Database : Northwind
Report created by EasyStruct 4.5 on 8/16/2004
  Tables   Views   Stored Procedures   Indexes

Summary of Sales by Year Top
create view "Summary of Sales by Year" AS
SELECT Orders.ShippedDate, Orders.OrderID, "Order Subtotals".Subtotal
FROM Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID
WHERE Orders.ShippedDate IS NOT NULL
--ORDER BY Orders.ShippedDate

Dependencies Top
Table Name Column Name
Orders OrderID
Orders ShippedDate
Order Subtotals OrderID
Order Subtotals Subtotal
Tables Views Stored Procedures Indexes