Re: 4.1.1 not an update or upgrade of 4.1.0

2004-01-20 Thread Victoria Reznichenko
Director General: NEFACOMP [EMAIL PROTECTED] wrote: 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

4.1.1 not an update or upgrade of 4.1.0

2004-01-19 Thread Director General: NEFACOMP
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

Re: 4.1.1 not an update or upgrade of 4.1.0

2004-01-19 Thread Aman [System Support]
Hi, I also faced this kind of error in sub query, any solution for this?: -Aman. On Mon, 19 Jan 2004, Director General: NEFACOMP wrote: 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