<cfquery name="getResultSet">
SELECT ( SELECT ProductName + ','
           FROM table2 t2
           WHERE t2.id = t1.id
           FOR XML PATH('') ) AS a,
    b,
    c
      FROM table1 t1
</cfquery>