> Kalin, > > Kalin> thanks to all... yes, Rhino - i'm new. my first > Kalin> post. the version is the problem indeed. it's > Kalin> 4.0.13-standard. how would i achieve the same > Kalin> query in this version?... > > You'll need to provide the following: > > (1) What is the result you want to achieve? well: this is what i wrote: select t1.data from table1 as t1 where t1.zip=(select * from table2 as t2 where t2.chain like "%carmike%");
i guess this will make more sense: basically i'm looking for the data in t1.data - which is varchar - that has a zip value of the record(s) that contain the name "carmike" in their "chain" field in table2... does this make sense? > (2) What are the details of the tables in the join > (column names & data types)? > > Regards, > Adam > > > -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]