"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 (f
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
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 quer
