I want to get a list of all the parents with the age and the name of the older child they've got. Let's say that a parent can't have 2 children with the same age.
I can solve my problem by using multiple queries but that's not very clean and a bit heavy (especially if there are lots of parents).
This is a perfect example of a "max-concat" query.
Look up "max concat" on the mysql website, and it should show you a similar problem with solution.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]