Simon Gentile <[EMAIL PROTECTED]> wrote:
> in version 4.1 states it supports subqueries like
>
> SELECT * FROM t1 WHERE (1,2,3) IN (SELECT a,b,c FROM
> t2);
>
> it doesn't support 'IN'
>
> [Dissertation] ERROR 1235: This version of MySQL
> doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
i implemented a very simple subquery using 'IN' and i
get the same message
"Dissertation] ERROR 1235: This version of MySQL
doesn't yet support 'LIMIT & IN/ALL/ANY/SOME
subquery'"
other subqueries DO work, but i cant get one to work
with 'IN'
__
It does,
I executed the following and it worked:
SELECT * FROM table1
WHERE (field1, field2) IN (SELECT field1, field2 FROM table2)
I think your problem is that you used constants (1,2,3) instead of using
fields.
Also I don't know if the fields don't need to be of the same type.
I just need to ch
