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.
please explain.
actually i should say that there are no examples of SUM() or AVG() --
or any of the other GROUP BY functions -- that are used with a join on
that page.
that's why i mentioned the join. sorry. i should have been more clear.
- philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]