* Richard
[...]
> When the same code is run but without the line:
>
> AND individual_id ='AB00090004' AND Category = 'DXS1047'
>
> a fragment of the results is:
>
> +--+---++---+-+-+
> | category | Individual_ID | Inactivate | count | minkey | m
>
>Hi I have 2 mySQL fragments that pull up 2 differing results and I have no
>idea why. The two pieces of code are identical bar one line which is :
>
>AND individual_id ='AB00090004' AND Category = 'DXS1047'
>
>The code that produces the correct code is:
>
>select Raw3_2.category,
> Ra
Hi I have 2 SQL fragments that pull up 2 differing results and I have no
idea why. The two pieces of code are identical bar one line which is :
AND individual_id ='AB00090004' AND Category = 'DXS1047'
The code that produces the correct code is:
select Raw3_2.category,
Raw3_2.Individua