SQL - transposing data from duplicate records
Posted on 2013-06-26
Okay here's what I'm trying to do.
I have a table with the columns
When I query it comes out like:
What I want is:
1 product1, product2, product4
2 product3, product4
3 product3, product2
Any thoughts? I've been trying this via SQL and Coldfusion, but I'm stumped after 2 days.