Northwind
Basic Index Expanded Index
| View Name: | Summary of Sales by Year |
| Field | Type | Nulls? | | ShippedDate | datetime | Yes |
| OrderID | int | No |
| Subtotal | money | Yes |
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