Posted on 2011-02-14
Hello EE World,
I'm trying to figure out the best way to write up a query to do the following.
let's say in a table i have a customer for each customer they will buy a certain number of services and each will have an expiration date. what i want to get on the same line is:
Count followed by a semi colon of each service and expiration date:
4;product1, 01/01/2011;product2, 01/20/2011; product3, 02/28/2011;product4,04/01/2011
column names are product, exp date the count is just calculated from how many products the client may have purchased.......