I'm trying to group some sub categories with a concatenated result. I'm trying to get the max sub for each item per month. I think it should be fairly easy but it is kicking my butt. My data looks like this, +--------+--------+------+ | month | item | sub | +--------+--------+------+ | 8 | 5 | NULL | +--------+--------+------+ | 8 | 4 | a | +--------+--------+------+ | 8 | 6 | NULL | +--------+--------+------+ | 8 | 6 | a | +--------+--------+------+ | 8 | 5 | a | +--------+--------+------+ | 8 | 4 | b | +--------+--------+------+ | 9 | 1 | NULL | +--------+--------+------+ | 9 | 2 | NULL | +--------+--------+------+ | 9 | 1 | a | +--------+--------+------+ | 9 | 3 | NULL | +--------+--------+------+ | 9 | 2 | a | +--------+--------+------+ | 9 | 1 | b | +--------+--------+------+ | 9 | 4 | NULL | +--------+--------+------+ | 9 | 4 | a | +--------+--------+------+ | 9 | 2 | b | +--------+--------+------+ | 9 | 1 | c | +--------+--------+------+ | 10 | 1 | NULL | +--------+--------+------+ | 10 | 1 | a | +--------+--------+------+ | 10 | 2 | NULL | +--------+--------+------+ I'm not having a problem getting a concatenated result but I am having difficulty getting my data grouped correctly. My results should look like this. +-----------+ | MAX Group | +-----------+ | 8-4b | +-----------+ | 8-5a | +-----------+ | 8-6a | +-----------+ | 9-1c | +-----------+ | 9-2b | +-----------+ | 9-3 | +-----------+ | 9-4a | +-----------+ | 10-1a | +-----------+ | 10-2 | +-----------+
- Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]