Just to follow up, here is the statement I ended up with. Only tested it directly, haven't done anything with the result set in PHP yet. Thanks for the solution Phil! SELECT title, MIN(eventDate) AS FirstDate, GROUP_CONCAT(DATE_FORMAT(eventDate, '%c/%e') ORDER BY eventDate Separator ', ') AS EventDateString FROM tbl_event INNER JOIN tbl_eventDates USING (eventID) WHERE eventDate >= Current_Date GROUP BY title ORDER BY FirstDate; I changed it slightly, but only just. Thanks again! Ron -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Pringle, Ron Sent: Tuesday, November 14, 2006 8:44 AM To: thelist at lists.evolt.org Subject: Re: [thelist] Problem with SQL Query - using PHP and MySQL Thanks Phil, Matt and Paul! I shall give your suggestions a try. Since, ideally, I'd like to order the events by date (at least by first occurance), I'll try Phil's suggestion first and work from there. Regards, Ron -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !