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' ________________________________________________________________________ Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]