D. Richard Hipp said: >Can anybody suggest some kind of extended SQL syntax that >could be added to SQLite that would make this kind of thing >easier?
I don't know if an equivalent is in the SQL standard, but MySQL added such a feature in their newish 4.1 release, called GROUP_CONCAT (see syntax at this url): http://www.mysql.com/doc/en/GROUP-BY-Functions.html Regardless of the details of how you do it, yours should definately be implemented as a function used with GROUP BY, just like the standard COUNT or AVG or SUM et al are. -- Darren Duncan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]