> > ----- Original Message ----- > From: "kalin mintchev" <[EMAIL PROTECTED]> > To: "Adam" <[EMAIL PROTECTED]> > Cc: "MySQL General" <[EMAIL PROTECTED]> > Sent: Sunday, November 14, 2004 11:33 PM > Subject: Re: syntax question.. > > >> >> > 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? >> > > Not entirely. It sounds like you are saying that the zip value is in the > column called 'data'. From your query, it appears that the zip code is in > the column called 'zip'. I *think* you mean to say that for every row in > table1 that contains a give the same zip code as the zip code of > '%carmike%', you want to see some other information in the same row, which > you are calling 'data' in your example. > > There are probably a few different ways to do this query. I'm going to > suggest one possible approach but it is not necessarily the best one; > others > may come along later to suggest a better approach. > > 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 haven't provided full descriptions of the tables and their columns and > I > have no idea what the data in the tables actually is so I can't try this > for > you to be sure it works. However, it should be pretty close to what you > need. Give it a try and let us know what error messages you get. If you > don't get error messages but the result is incorrect, describe the result > that you got and how it differed from the result you expected. Then we can > probably help you figure out what went wrong. > > Rhino > > -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]