First, have you tried GROUP_CONCAT(DISTINCT types) ? Second I see my counts rise just as my group_concat() terms when I do something similar to what you're talking about. Also, here:
val c_types d_types 3 t9,t9,t9 a2,a3,a9 Your column headers don't seem to match your query. I don't see the count "n" being output at all in the example. Are you sure you're looking at count() and not something else? Count should count all non-null instances of foo (or count(*) works too). Thanks, Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
