On 2015/05/07 19:42, Paul Halliday wrote:
Should have showed the whole thing. Take a look here (click image to see
full output):
http://www.pintumbler.org/tmp
I don't see why this worries you. Joining often increases variation.
Indeed, if in some case an inner join never did, maybe the joined
Should have showed the whole thing. Take a look here (click image to see
full output):
http://www.pintumbler.org/tmp
On Thu, May 7, 2015 at 4:11 PM, shawn l.green
wrote:
> Hi Paul,
>
> On 5/7/2015 10:17 AM, Paul Halliday wrote:
>
>> Fighting a bit with this one...
>>
>> If I do something like (
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
3t9,t9,t9 a2,a3,a9
Your column headers don't seem to match your query.
Hi Paul,
On 5/7/2015 10:17 AM, Paul Halliday wrote:
Fighting a bit with this one...
If I do something like (pseudo):
SELECT count(val) AS n, GROUP_CONCAT(types) AS c_types FROM tbl1
returns something like:
n c_types
1 t9
when I add a left join though:
SELECT count(val) AS n, GROUP_CONCAT(
Fighting a bit with this one...
If I do something like (pseudo):
SELECT count(val) AS n, GROUP_CONCAT(types) AS c_types FROM tbl1
returns something like:
n c_types
1 t9
when I add a left join though:
SELECT count(val) AS n, GROUP_CONCAT(types) AS c_types,
GROUP_CONCAT(two.types) AS d_types