re: mysql 5.07 results incorrect, mysql 5.0.6 results correct

2005-07-13 Thread SGreen
replies embedded James Black <[EMAIL PROTECTED]> wrote on 07/13/2005 10:03:09 AM: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > If I run the first query on mysql 5.0.6 the results are correct, I get > 142 rows, if I run it on 5.0.7 I get 8 rows back. > > If I remove the nested selec

re: mysql 5.07 results incorrect, mysql 5.0.6 results correct

2005-07-13 Thread James Black
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 If I run the first query on mysql 5.0.6 the results are correct, I get 142 rows, if I run it on 5.0.7 I get 8 rows back. If I remove the nested select, as shown in the second query, then it works fine on 5.0.7. I am trying to understand what is going