RE: glitch or me?

2002-03-14 Thread Roger Baklund
* 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

glitch or me?

2002-03-14 Thread Richard
> >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

glitch or me?

2002-03-14 Thread Richard
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