thanks to all... yes, Rhino - i'm new. my first post. the version is the problem indeed. it's 4.0.13-standard. how would i achieve the same query in this version?...
thank you.. > Hi > sub selects are only supported from MySql 4.1 onwards, so it may be invalid > if you have an earlier version. > you may also cause a conflict by using the database alias (t1) as the name > of the result > Peter >> -----Original Message----- >> From: kalin mintchev [mailto:[EMAIL PROTECTED] >> Sent: 14 November 2004 23:06 >> To: [EMAIL PROTECTED] >> Subject: syntax question.. >> hi everybody.. >> can somebody please explain what is wrong with this command: >> select t1.data from table1 as t1 where t1.zip=(select * from table2 as t2 >> where t2.chain like "%carmike%"); >> thank you... >> -- >> -- >> 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] -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]