> >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, > Raw3_2.Individual_ID, > Raw3_2.Inactivate, count(*) as count, > min(key_num) as minkey, > max(key_num) as maxkey > from Raw3_2 where individual_id not like "control%" and inactivate=0 > AND individual_id ='AB00090004' AND Category = 'DXS1047' > group by category,Individual_ID,Inactivate > >gives the CORRECT result below: > >+----------+---------------+------------+-------+---------+---------+ >| category | Individual_ID | Inactivate | count | minkey | maxkey | >+----------+---------------+------------+-------+---------+---------+ >| DXS1047 | AB00090004 | 0 | 3 | 2027223 | 2064251 | >+----------+---------------+------------+-------+---------+---------+ > >Here the count is three, which is correct. > >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 | maxkey | >+----------+---------------+------------+-------+---------+---------+ >| DXS1047 | AB00090004 | 0 | 1 | 2027223 | 2027223 | >+----------+---------------+------------+-------+---------+---------+ >| DXS1047 | AB00090004 | 0 | 2 | 2063277 | 2064251 | >+----------+---------------+------------+-------+---------+---------+ > >Any ideas why? Any help would be greatly appreciated, > >Thanks in advance >Rich
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
