|< < 14 > >|

Slightly more complicated queries

Anything involving the Products ordered by a Customer.

Example: Find Products ordered by a Customer on a given date:

• Lookup by Customer key.

• Find Order on given date.

• Scan all Items. For each item:

  • Find Product: Look up Product key in the Product hierarchy.

|< < 14 > >|