and GROUP BY

[Ted Vinke]

All,   I've got forums, topics and messages related with eachother and now I'm trying to generate a forum-overview sorted by date of the most recent message:   --------------------------------------------------------- forumname    | topics    | messages    | modified --------------------------------------------------------- General          5         2            27/04/2004 Misc             6         1            23/04/2004   Roughly I'm using the following construction:   <mm:list               path="forum,topic,message"               fields="forum.name,forum.subject,forum.number,message.date"               orderby="message.date"               directions="UP"               distinct="true"               >   This however will return a record for every message there is in a forum causing e.g. the forum "General" to appear twice in the list, because there are 2 messages inside (topics inside) that forum. It seems that the only way to keep message in the path and get the results I want is to have some sort of GROUP BY part which groups by forumname, but I haven't been able to figure out how. The documentation speaks of distinct and constraints etc., but can somebody tell me if I can use <mm:list> with a GROUP BY part or do I have to use another construction?   Thanks!   Regards, Met vriendelijke groet, Ted Vinke   First8 BV Groenestraat 294 6531 JC Nijmegen [EMAIL PROTECTED]