If you use mysql 4.1, you can use GROUP_CONCAT(). See the manual for
details <http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html>.
Michael
Paul McNeil wrote:
Thank you for your response, Egor. My question is whether or not it is
possible to concatenate the fields without knowing the event ID.
pseudo SQL
Select concat(data from all grouped fields) from foo group by (eventID);
God Bless
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web technologies.
Microneil Research
Sortmonster Anti Spam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]