Re: self-join, group by, single SQL query

[Robert Citek]

On Tuesday, November 11, 2003, at 03:06  PM, Roger Baklund wrote:

* Robert Citek
Is there a way to do a self-join and a group by in a single SQL query?
See the max-concat trick, described here:

<URL: 
http://www.mysql.com/doc/en/example-Maximum-column-group-row.html >
Thanks for the tip.  It looks like it should do the trick.  I'll 
experiment a bit and then post back  the results.

Again, thanks.

Regards,
- Robert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]