On 5/29/05, Philip George wrote: > On May 29, 2005, at 1:41 AM, Jochem van Dieten wrote: >> >> http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html > > already read that. the join in my example is more complicated than > anything depicted on that page.
The join is irrelevant. Your join returns a resultset and you can just pretent that resultset is a single table: SELECT field1, field2, field3 FROM (very complicated join) AS simpletable GROUP BY ... WITH ROLLUP Just copy-pate your join into this and fix the fieldnames. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
