Hello everyone. I have a customer purchase table that keeps track of transaction details. I'm looking sum up total spent by each customer and classify each customer based on which products they bought.
Data looks like... account_id, date, product_id, sale_price ----------------------------------------- cust1, 03/21/2005, prod1, 50 cust1, 03/22/2005, prod4, 35 cust1, 05/08/2005, prod2, 50 cust2, 04/21/2005, prod16, 20 cust3, 04/16/2005, prod1, 50 etc...... Setup: I'm picturing a Venn Diagram in my head but I need help with the decision logic to classify each customer. Example: Category A: Prod1, Prod2 Category B: Prod3, Prod4 Category C: All products Not in Class A or Class B -A customer who has bought Prod1, Prod2 would be in the A only category. -A customer who has bought Prod1, Prod3 would be in the Class A&B category -A customer who has bought Prod18 would be in the C category -A customer who has bought Prod4, Prod16 would be in the B&C category -A customer who has bought Prod1, Prod4, Prod15 would be in the A&B&C category -etc... Then for each comination of categories (7 in total?), i will need of number of accounts in that category and total spent by those accounts. Any help or direction would be greatly appreciated. Thank you in advance. -Vince __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly