Totaling by group

Let's say there is a database that keeps track of customers that buy a specific product...say DVD's.
There is a table which holds member information (member #, premiere_member,name, address, city, etc.) and a view which samples info about each member account (using the handy-dandy decode function) and returns info like total # of orders by premiere_member, total # of orders by non-premiere members,etc.).

I have a report (in SQR) that shows the totals grouped by city....no problem.
Now, I want a report that shows the totals by household...a household is defined by the last name, address and city. So, even if there are three people with the same last name, address and city that have ordered, this only counts as 1.

I hope this makes sense. Any ideas out there?

Thanks,
A. Mills
cici_at_erols.com Received on Wed Aug 25 1999 - 08:56:23 CDT