Web lists-archives.com

Re: Why does a group_concat on a join change aggregate values?




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