I'm working on a project to find the association rule of items for Market dataset. I have a huge database that contains multi-tables. The output I got from this query
select sales_fact_1997.customer_id, sales_fact_1997.product_id, product.product_name from sales_fact_1997 , product where sales_fact_1997.product_id = product.product_id group by sales_fact_1997.customer_id , sales_fact_1997.product_id order by sales_fact_1997.customer_id, product.product_name;
is like that:
customer_id product_id product_name 13 1466 Hot Dogs 13 937 American Cole Slaw 13 10 Akron City Map ...
Is there a way to get the output in this format:
customer_id product_id product_name 13 1466,937,10 Hot Dogs, American Cole Slaw, Akron City Map