Northwind › Views
Order Details Extended view
2155 rows. A view stores a SELECT statement, not rows: each time you open it, SQLite runs the query again.
Columns
| # | Name | Type | Not null | Default | Key | References |
|---|---|---|---|---|---|---|
| 0 | OrderID |
INTEGER |
no | — | ||
| 1 | ProductID |
INTEGER |
no | — | ||
| 2 | ProductName |
TEXT |
no | — | ||
| 3 | UnitPrice |
REAL |
no | — | ||
| 4 | Quantity |
INTEGER |
no | — | ||
| 5 | Discount |
REAL |
no | — | ||
| 6 | ExtendedPrice |
(none) | no | — |
Definition
CREATE VIEW "Order Details Extended" AS
SELECT "Order Details".OrderID, "Order Details".ProductID, Products.ProductName,
"Order Details".UnitPrice, "Order Details".Quantity, "Order Details".Discount,
round("Order Details".UnitPrice * Quantity * (1 - Discount), 2) AS ExtendedPrice
FROM Products INNER JOIN "Order Details" ON Products.ProductID = "Order Details".ProductID