I'm not sure this will work for you, but look at the GROUP BY clause and
the
GROUP_CONCAT() function.
That was exactly what I needed! I converted my query as follows, and I'm
getting exactly what I was looking for:
SELECT S.*, CONCAT(C.FirstName,' ',C.LastName) AS CounselorName,
(SELECT Count(*) FROM CamperActivitySelections WHERE SectionID=S.ID)
AS Cap,
CONVERT(GROUP_CONCAT(StartDateTime ORDER BY StartDateTime SEPARATOR
'<br>'),Char) As Sh
FROM Sections S
LEFT JOIN Counselors C ON C.ID=S.CounselorID
LEFT JOIN (SELECT SectionID,StartDateTime FROM SectionSchedule SS) As SS
ON SS.`SectionID`=S.ID
WHERE ActivityID=65
GROUP BY S.ID
THANKS FOR THE HELP!
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
