[thelist] MySQL Query Issue

[Marcus Andersson]

I'm not sure if this is what you want and it's MySQL 4.1 but...

SELECT
   P.productName,
   P.shortDesc,
   P.longDesc,
   GROUP_CONCAT(CS.classDate) as classDates
FROM
   PRODUCTS P LEFT JOIN CLASSES_SCHEDULE CS ON P.productID = CS.productID
GROUP BY
   P.productID

This results in one row/product with every class date in a comma separated list in classDates

/Marcus