<div>
Thank you both! &nbsp;I had gone down the SQL path and was way over complicating the issue.
</div>


Thank you both!  I had gone down the SQL path and was way over complicating the issue.

<div>
<div class="content wysiwyg-content">
Okay here's what I'm trying to do.<br />
<br />
I have a table with the columns<br />
<br />
customer_id product_purchased<br />
<br />
When I query it comes out like:<br />
<br />
1 product1<br />
1 product2<br />
1 product4<br />
2 product3<br />
2 product4<br />
3 product3<br />
3 product2<br />
<br />
What I want is:<br />
1 product1, product2, product4<br />
2 product3, product4<br />
3 product3, product2<br />
<br />
Any thoughts? &nbsp;I've been trying this via SQL and Coldfusion, but I'm stumped after 2 days.
</div>
</div>


Okay here's what I'm trying to do.

I have a table with the columns

customer_id product_purchased

When I query it comes out like:

1 product1
1 product2
1 product4
2 product3
2 product4
3 product3
3 product2

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.

SQL - transposing data from duplicate records

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

ColdFusion Language

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.