Read-only Back to SQLite3 Guide
Northwind › Products › 21
Sir Rodney's Scones

Products row where ProductID = 21. Blue values are foreign keys: click one to jump to the row it points at.

Record
See the SQL ›
ProductIDPK
21
ProductName
Sir Rodney's Scones
SupplierIDFK
8
CategoryIDFK
3
QuantityPerUnit
24 pkgs. x 4 pieces
UnitPrice
10.0
UnitsInStock
3
UnitsOnOrder
40
ReorderLevel
5
Discontinued
0
Order Details via ProductID
39 rows
row OrderIDProductIDUnitPriceQuantityDiscount
open › 10259 21 8.0 10 0.0
open › 10261 21 8.0 20 0.0
open › 10333 21 8.0 10 0.1
open › 10368 21 8.0 5 0.1
open › 10397 21 8.0 10 0.15
open › 10406 21 8.0 30 0.1
open › 10409 21 8.0 12 0.0
open › 10430 21 8.0 50 0.0
open › 10456 21 8.0 40 0.15
open › 10461 21 8.0 40 0.25
open › 10477 21 8.0 21 0.25
open › 10484 21 8.0 14 0.0
open › 10504 21 10.0 12 0.0
open › 10513 21 10.0 40 0.2
open › 10539 21 10.0 15 0.0
open › 10550 21 10.0 6 0.1
open › 10609 21 10.0 6 0.0
open › 10614 21 10.0 8 0.0
open › 10619 21 10.0 42 0.0
open › 10623 21 10.0 25 0.1
open › 10642 21 10.0 30 0.2
open › 10658 21 10.0 60 0.0
open › 10681 21 10.0 12 0.1
open › 10716 21 10.0 5 0.0
open › 10717 21 10.0 32 0.05
open › 10729 21 10.0 30 0.0
open › 10731 21 10.0 40 0.05
open › 10763 21 10.0 40 0.0
open › 10861 21 10.0 40 0.0
open › 10873 21 10.0 20 0.0
open › 10884 21 10.0 40 0.05
open › 10929 21 10.0 60 0.0
open › 10930 21 10.0 36 0.0
open › 10956 21 10.0 12 0.0
open › 10978 21 10.0 40 0.15
open › 10990 21 10.0 65 0.0
open › 11034 21 10.0 15 0.1
open › 11040 21 10.0 20 0.0
open › 11058 21 10.0 3 0.0