SQLite Forum

Repeat values n times
Login
Chronological Hierarchical 
That now makes sense. Stating the business case "I want to print labels for the items of an order" woudl have provided the necessary context.