Northwind › Views
Orders Qry view
830 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 | CustomerID |
TEXT |
no | — | ||
| 2 | EmployeeID |
INTEGER |
no | — | ||
| 3 | OrderDate |
TEXT |
no | — | ||
| 4 | RequiredDate |
TEXT |
no | — | ||
| 5 | ShippedDate |
TEXT |
no | — | ||
| 6 | ShipVia |
INTEGER |
no | — | ||
| 7 | Freight |
REAL |
no | — | ||
| 8 | ShipName |
TEXT |
no | — | ||
| 9 | ShipAddress |
TEXT |
no | — | ||
| 10 | ShipCity |
TEXT |
no | — | ||
| 11 | ShipRegion |
TEXT |
no | — | ||
| 12 | ShipPostalCode |
TEXT |
no | — | ||
| 13 | ShipCountry |
TEXT |
no | — | ||
| 14 | CompanyName |
TEXT |
no | — | ||
| 15 | Address |
TEXT |
no | — | ||
| 16 | City |
TEXT |
no | — | ||
| 17 | Region |
TEXT |
no | — | ||
| 18 | PostalCode |
TEXT |
no | — | ||
| 19 | Country |
TEXT |
no | — |
Definition
CREATE VIEW "Orders Qry" AS
SELECT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate,
Orders.RequiredDate, Orders.ShippedDate, Orders.ShipVia, Orders.Freight,
Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion,
Orders.ShipPostalCode, Orders.ShipCountry,
Customers.CompanyName, Customers.Address, Customers.City,
Customers.Region, Customers.PostalCode, Customers.Country
FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID