Hi group, I have discovered this morning a strange behaviour of MySQL 4.1.1 When the SUB-SELECT contains more than one field, it does not work (this works very well with 4.1.0 !!!!)
For example: SELECT field1 FROM Table1 WHERE (field2,field3) IN (SELECT field2,field3 FROM Table2) The above query works as expected with mysqld-nt.exe 4.1.0 (on WinXP) but it does not work with mysqld-nt.exe 4.1.1 (on WinXP). This problem causes unexpected results as the recordset comes empty (on 4.1.1) while it comes with rows with 4.1.0 and no error is returned!!! Maybe it is a known bug!!!!! Thanks, __________________________________ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/