1.13.5 Example 5: Aggregate data from the sales history table and customer table
From the sales history table (SALESLIST) and customer table (USERSLIST), obtain the sum by customer of the quantities purchased (PUR-NUM) on or after September 4, 2011 for product code P002.
- Table to search
- Specification example
-
SELECT "NAME",SUM("PUR-NUM") FROM "SALESLIST","USERSLIST" WHERE "PUR-DATE">=DATE'2011-09-04' AND "PUR-CODE"='P002' AND "SALESLIST"."USERID"="USERSLIST"."USERID" GROUP BY "NAME"
- Retrieval results