MySQL 4.1 subqueries!

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' ___

Re mysql 4.1 subqueries

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' __