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]