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 check the manual. Thanks Emery ----- Original Message ----- From: "Simon Gentile" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 23, 2003 11:59 Subject: 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' > > ________________________________________________________________________ > 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] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
