Re: Why does a group_concat on a join change aggregate values?
- Date: Thu, 7 May 2015 17:01:18 -0400
- From: Bob Eby <ebyrob@xxxxxxxxx>
- Subject: 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).
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql