> > > > I think you need to do something like this: > > > > select t1.data > > from table1 t1 inner join table2 t2 on t1.zip = t2.zip > > where t2.chain like '%carmike%'; > > i tried this one... it seams to work. i'll read a bit more about joins .. > thank you... appreciate it... > You're welcome!
Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]